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