Try this ...
SELECT m.id
,m.text
FROM main m
,recs r
WHERE m.id = r.id
AND r.log like '%sometext%'
ORDER BY m.id
/
Roy A. Jones
"Rick" <rosen@xxxxxxxxxxxxxx>
13-Oct-2006 10:53
To
php-db@xxxxxxxxxxxxx
cc
Subject
Re: Problem with Oracle query
"Brad Bonkoski" <bbonkoski@xxxxxxxxxxxxxx> wrote in message
news:452FA592.6020602@xxxxxxxxxxxxxxxxx
> 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...
Thanks, but I want to retrieve only one row for ID field (row from Main
table) where the string contains in second table.
Something like this:
ID Text
1 Sometext 1
2 Sometext 2
6 Sometext 3
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
