Strange. Let me look into it.

>
>exactly! However if I 'extend' this little example with
>

>insert into curOrdertype values(3,"nbrthree")
>

>and
>

>insert into curClient values(4,"George")
>

>this will give me a 0.00 for all orders ;(
>
>Regards,
>
>Koen
>>You do need Cartesian product for curOrdertype and curClient
>>Try
>>

>>SELECT curClient.cName, CAST(NVL(curOrder.nAmount, 0.00) AS N(8,2)) AS Amount, curOrdertype.cType ;
>>	FROM curOrdertype, curClient ;
>>		LEFT JOIN curOrder ON curOrder.iOrdertype = curOrdertype.ID ;
>>				AND curOrder.iClient = curClient.ID ;
>>	ORDER BY curClient.ID, curOrdertype.ID 			
>>

>>