Re: Problem with Oracle query

"Brad Bonkoski" <bbonkoski@mediaguide.com> wrote in message news:452FA592.6020602@mediaguide.com... > 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