>SET DELETED OFF
> SELECT Field1, Field2 ;
> FROM Table1 JOIN Table2 ON Table1.Field3 = Table2.Field4 ;
> WHERE !DELETED("Table1") ;
> AND DELETED("Table2")

>The deleted() doesn't work.

> How about the 2 Select statements?

> Kev

set deleted off
select field1,field2 from table1 where not(deleted('table1')) into cursor cursor1
set deleted on
select cursor1.field1,field3,field4 from cursor,table2;
where cursor1.field1 = table2.field3