MYSQL question

admin

Administrator
Staff member
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 ...
 
Back
Top