>>>
>>>Hah? How is it different from what I posted a week ago <B>Re: SQL Select union with empty rows</B> Message #1474131 ?
>>

>You didn't even bother to read my message because it's not the query I suggested in it.
>Here it's copied from my message 
><pre>
>SELECT curClient.cName, CAST(NVL(curOrder.nAmount, 0.00) AS N(8,2)) AS Amount, curOrdertype.cType ;
>	FROM curOrdertype FULL JOIN curClient ON .T. ;
>		LEFT JOIN curOrder ON curOrder.iOrdertype = curOrdertype.ID ;
>			AND curOrder.iClient = curClient.ID ;
>	ORDER BY curClient.ID, curOrdertype.ID 		
>

Sergey,,

Indeed, I was referring to your 1st solution #1474122 and not to your correction as per message #1474131. My mistake.
Hope we can stil be friends?

Best regards,

Koen