I am selecting two records from two tables the second table may not have the matching record yet. I get a ".NULL." back from the select.
Is there a way to get a 0 (zero) or a blank if there is no match from the LEFT OUTER JOIN? I know that I can ASCAN() the array I was wondering if I can do this in the SELECT???
SELECT Crafts.crafttitle, Craftpay.payrate;
FROM jobtrack!Crafts;
LEFT OUTER JOIN jobtrack!CraftPay;
ON Crafts.craftid = Craftpay.craftid;
INTO ARRAY laData