I'm working with a Delete Query that includes two joined tables, and I'm having an issue figuring out how to designate the table that I want to delete records from. I've looked at several of the EE "DELETE * FROM" examples, but I can't seem to get the query configured properly.
This is the query that I started with:
DELETE CompSales_Beta.Sale_Index, CompSales_Beta.Date_Modified AS Comps_Mod_Date, Archived_CompSales.Date_Modified AS Arch_Mod_Date
FROM CompSales_Beta INNER JOIN Archived_CompSales ON CompSales_Beta.Sale_Index = Archived_CompSales.Sale_Index
Any input is appreciated