I am trying to write a SQL-Select and am running into a very interesting problem. The first two SQL's function properly returning a cursor with the expected results. When I try to put the two together, the return cursor is empty. Any thoughts?

Both Tables (tbl_1 and tbl_2) share a pair of fields (fld_a and fld_b) . Fld_c is only in tbl_1.

SQL 1
-------
SELECT fld_a + fld_b AS ab, fld_c FROM tbl_1 WHERE DELETED()

SQL 2
-------
SELECT fld_a + fld_b AS ab, fld_c FROM tbl_1 WHERE fld_a + fld_b IN (SELECT fld_a + fld_b FROM tbl_2)

SQL 3
-------
SELECT fld_a + fld_b AS ab, fld_c FROM tbl_1 WHERE DELETED() .OR. fld_a + fld_b IN (SELECT fld_a + fld_b FROM tbl_2)

Thanks in advance.

Todd Cottengim
Alpine Land Information Services