Rosen wrote:
Hi,
I have a problem with PHP and Oracle SQL query.
I have 2 tables :
Table Main:
-----------
id number
text varchar2(100)
Table Recs
-----------
id number
pos number
log varchar2(200)
I need to make query to select a list from first table(Main), where
somewhere in the second table (Recs), the log field contains some
string. The records for one ID from Main table can be many in table
Recs. ( Table Recs acts as log for every row from table Main).
Can someone help me with this query?
Thanks in advance,
Rosen
select m.id, r.log from main m left outer join recs r on r.id = m.id
This will output something like:
Id log
1 log item 1
1 log item 2
1 log item 3
2 another log
etc...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
