Yes, Thath is ! Thank you very much! <roy.a.jones@xxxxxxx> wrote in message news:OF28B02AF2.0A8D473D-ON85257206.00545190-85257206.0054878B@xxxxxxxxxx > When you say so much rows I am assuming you mean 1 row from MAIN for every > row in RECS. If that is true and you just want 1 MAIN row then I would > add DISTINCT or EXISTS or IN ... > > SELECT DISTINCT > 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 > Yes, Thath is ! Thank you very much! > > > > "Rosen" <rosen@xxxxxxxxxxxxxx> > 13-Oct-2006 11:09 > > To > php-db@xxxxxxxxxxxxx > cc > > Subject > Re: Problem with Oracle query > > > > > > > > > <roy.a.jones@xxxxxxx> wrote in message > news:OF4327B8B7.97B4FBCB-ON85257206.005248C5-85257206.005256B2@xxxxxxxxxx >> 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 >> / > > Thanks, but this retrieves me so much rows as many are the appearance the > 'sometext' in the Recs table > > > > > > >> >> >> 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 >> >> >> >> > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
