On Fri, 02 Oct 2009 13:37:49 S.Mohammed Alsharaf wrote: > try this > > SELECT item.productid, `quantity` , price, title , > FROM `item` > > JOIN `product` ON product.productid = item.productid > > LEFT JOIN `prices` AS p ON prices.productid = item.productid > WHERE p.productid = item.productid > AND p.the_company = '1' > AND p.the_forex = 'NZD' > AND p.the_level = '1' > > AND`uid` = 'deleted' > ORDER BY `productid` > LIMIT 0 , 30
Thank you Mohammed - Just what I needed :-) --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
