Re: need help to build a query

But, in this case I will have repeating order_date and order_status info? id order_date status file_name 12 2006-10-09 live file1.jpg 12 2006-10-09 live file2.jpg 12 2006-10-09 live file3.jpg 13 2006-10-09 live file1.jpg 14 2006-10-09 live test.gif right? > 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 > > HTH, > John W > > >> >> thanks for any help. >> >> -afan >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >