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

The DELETED() function with an alias will not work in a SQL SELECT statement.