supyall,
here's the simple pb ... I'm looking for a simple solution, but 100% SQL (I use php for every day website .. but this time ... I had to implement a Delphi GUI
2 tables let's call them
customer [name,id_customer]
bill [ammount,date,id_bill,id_customer]
a customer can have 1 or more bills ....
I want to get a result with all customers aned their LAST bill only.
is that possible in SQL only ?
thanks a lot !
etienne
PS : I tried to GROUP but the ORDER clause is used after grouping ...
here's the simple pb ... I'm looking for a simple solution, but 100% SQL (I use php for every day website .. but this time ... I had to implement a Delphi GUI

2 tables let's call them
customer [name,id_customer]
bill [ammount,date,id_bill,id_customer]
a customer can have 1 or more bills ....
I want to get a result with all customers aned their LAST bill only.
is that possible in SQL only ?
thanks a lot !
etienne
PS : I tried to GROUP but the ORDER clause is used after grouping ...