hello, how to do this :
select Id_contact, (select First 1 skip 0 Amount, currency from invoice where ID_invoice=id_contact and ...) as amount_last_invoice, currency_last_invoice from contact off course i can do 2 time (Select Amount ...) as amount_last_invoice, and (Select Currency ...) as currency_last_invoice ... but i think their is a better way no ?
