Table1: Custno Sales ABCD 40000 XYZS 20000 Table2: Custno Sales XYZS 100 YYYY 7000I want to come up with SQL that will generate a cursor called cursor1 with total sales for each customer:
Cursor1: Custno TotalSales ABCD 40000 XYZS 20100 YYYY 7000Note that custno ABCD is absent from table2, XYZS is present in both and YYYY is absent from table1. Also, please note that this is for VFP 5, so nesting SELECTs may not work.