Hi,

I have a query like this :

SELECT A.CUSTNO,
(SELECT B.FAKTUUR_EUR FROM FAKTUUR_XP1 B WHERE (B.KLANTNR = A.CUSTNO) AND
(B.JAAR = 2001)) AS JAAR_2001,
(SELECT B.FAKTUUR_EUR FROM FAKTUUR_XP1 B WHERE (B.KLANTNR = A.CUSTNO) AND
(B.JAAR = 2002)) AS JAAR_2002
FROM CUST A
ORDER BY A.CUSTNO

I need some values next to each other in a DBGrid, a customer with invoice
information from year 2001 and 2002, so that's why I needed a query like
this. The problem now is, I have to update the fields JAAR_2001 and
JAAR_2002. Is this possible ? Becuase they are referred as a alias. I
was thinking of the EditSQL property with a stored proc ?

Thanks in advance,

Nico Callewaert