Access Syntax Error

[reddsables]

Hi all. What am I missing in this query? Access is telling me that I have a syntax error. It works in MySQL though. Thank you!

delete t1, t2, t3, t4
from (
select u.product, count(*) counter
from (
select * from table1 union all
select * from table2 union all
select * from table3 union all
select * from table4
) u
group by u.product
) t
left join table1 t1 on t1.product = t.product
left join table2 t2 on t2.product = t.product
left join table3 t3 on t3.product = t.product
left join table4 t4 on t4.product = t.product
where t.counter = 1;

 

[J.Ty.]

In general, the syntax of DELETE statements in SQL is
DELETE FROM table_name WHERE condition;

In your case, you are attempting to delete from a query, which makes little sense, because it is not materialized in the system and there is no way to delete from it.