The following SQL statement sometimes gives strange results- some of the INV fields will come back as .NULL. while others have values. The INV table does not contain .NULL. values. Is there something wrong with the syntax of the statement? I am using VFP 7. Thanks!
SELECT Whocust.wacct, sales.*,inv.miles,inv.whoseller,inv.color,inv.doors,inv.odometer, ;
inv.new_used,inv.decal,inv.county,inv.color;
FROM cardata!whocust LEFT OUTER JOIN cardata!sales;
LEFT OUTER JOIN cardata!inv ;
ON Inv.line = Sales.line ;
ON Whocust.wacct = Sales.sacct;
WHERE Whocust.wacct = myacct ;
ORDER BY sales.date, sales.make, sales.model ;
into cursor vwsinv
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!