select p.productid, o.orderid, orderdate

from products p

inner join [order details] od on od.productid = p.productid

inner join orders o on od.orderid = o.orderid

inner join (

select productid, max(orderdate) as maxOrderDate

from [order details]...

how about:

select productname, categoryid, max(od.orderid) as lastOrderID, max(orderdate) as lastOrderDate

from products p

left join [order details] od on od.productid = p.productid

left join orders o on od.orderid = o.orderid

where categoryid =...

silent, but daily.  me too.

http://www.devx.com/getHelpOn/10MinuteSolution/20508

The string "" is the code for a tilde "~" character.  If you display this string in an html page, the browser shows a tilde.  Are you html encoding before...

Alternatively, you could create a child table with a foreign key id field and a single text field, with 15 records for a given id representing the 15 lines you...