thanks a lot ... I could find the correct terms to search it !
the "one pass" solution is a little ugly for many columns.
maybe with subselect it will be easier :)
thanks again.
Hi there,
Suppose I have two tables, customer and order.
for 1 customer, I can have 0 or more orders with details.
how can I manage to get, for each customer, his last order, (considering the date). Of course I wanna get some info from customer table and order table.
example
with :
client...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.