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 ?