Re: need help to build a query
| From: | Richard Lynch | Date: | Tue, 10 Oct 2006 19:22:54 +0000 |
| Subject: | Re: need help to build a query | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-242930@lists.php.net to get a copy of this message | ||
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?