Re: need help to build a query

sure it is! ;) > On Mon, October 9, 2006 2:58 pm, John Wells wrote: >> On 10/9/06, afan@afan.net <afan@afan.net> wrote: >>> but I know there must be much better solution then this one. >> >> You're right: Simply JOIN your queries... >> >> SELECT order_id, order_date, order_status, file_name >> FROM orders >> JOIN uploaded_files AS uf ON orders.order_id = uf.order_id >> ORDER BY orders.order_id DESC >> LIMIT 100 > > This will "miss" all the orders with no upload at all, unlike the > original. > > AND it limits you to the 100 uploaded files, not 100 orders. > > This is a lot more subtle problem than it seems at first glance, eh? > > -- > Some people have a "gift" link here. > Know what I want? > I want you to buy a CD from some starving artist. > http://cdbaby.com/browse/from/lynch > Yeah, I get a buck. So? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >