Hi All:

Please consider the following:

Table1:

Custno     Sales
ABCD      40000
XYZS      20000

Table2:

Custno     Sales
XYZS      100
YYYY      7000

I 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      7000

Note 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.

Thanks,

Yossi