[PHP-DB] Question about advanced SQL

Hi. I need some guidance for writing an effective query (instead of processing through PHP). I lets says I have two tables, tblCDs and tblOrders. tblCD cdID| cdTitle | cdArtist -- 1 | Great Hits | Bon Jovi 2 | Forever

RE: [PHP-DB] Question about advanced SQL

tested the above query but it should work :-) Although it probably isn't the most efficient. [TK] -Original Message- From: Adam Royle [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 February 2002 1:38 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Question about advanced SQL Hi

Re: [PHP-DB] Question about advanced SQL

select * from tblCd where cdId not in (select distinct cdId from tblOrders); On Thu, Feb 28, 2002 at 12:37:49PM +1000, Adam Royle wrote: Hi. I need some guidance for writing an effective query (instead of processing through PHP). I lets says I have two tables, tblCDs and tblOrders.

Re: [PHP-DB] Question about advanced SQL

Hi, I assumed that you was used MySQL for database. With MySQL you can used this SQL to find different row select tblcd.* from tblcd left join tblorder on tblcd.cdid=tblorder.cdid where tblorder.cdid is null sommai At 12:37 28/2/2002 +1000, Adam Royle wrote: Hi. I need