Sele custno, fieldb ; from Table1 ; Into Cursor cursor1 sele cursor1.*, nvl(cursor2.sales, 0) ; from cursor1 c1 ; left outer join cursor2 c2 ; on c1.custno = c2.custno ; into cursor <b><i>cursor1</i></b> && <==Same NameI'm in VFP5, but that should no make any difference; I'll test that.