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>
>insert into curOrdertype values(3,"nbrthree") >>and
>insert into curClient values(4,"George") >>this will give me a 0.00 for all orders ;(