Delete query with joined tables
In Access 2020, I have a delete query like this. (Access is a front end to a SQL back end database.)
The SQL code is like this.
DELETE dbo_Client.*, dbo_Client.NewClient, dbo_Order.OrderId
FROM dbo_Client LEFT JOIN dbo_Order ON dbo_Client.ClientId = dbo_Order.ClientId
WHERE (((dbo_Client.NewClient)=True) AND ((dbo_Order.OrderId) Is Null));
When I run it, it says "Could not delete from specified tables."
It appears that the query needs to specify the table to delete from in a different way. Should I make this a select query and create a separate delete query on that, or is there a simpler way?