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?