Hi All,

How do I select records from multiple tables when looking for a deleted record?

In the following statement the deleted flag is not being respected:

SET DELETED OFF
SELECT table1.* ;
    FROM table1, table2 ;
    WHERE table2.myfield = table1.myfield ;
    AND DELETED("table1")

I realise that a VFP SQL statement opens tables again and gives them their own aliases. Is there any way to use DELETED() in a SQL statement with multiple tables?

Thanks,
Gavin.