L
lmr
I am trying to delete rows from one table by using criteria from a joined
table. I get an error message that says the data cannot be deleted.
This is the SQL - DELETE [CH Calls].*, [tbl RB Employees].Supervisor
FROM [CH Calls] INNER JOIN [tbl RB Employees] ON [CH Calls].Field2 = [tbl RB
Employees].[Login ID]
WHERE ((([tbl RB Employees].Supervisor) Like "moyer* or pilcher*" Or ([tbl
RB Employees].Supervisor) Like "range*"));
Where am I going wrong?
Thanks for any response.
table. I get an error message that says the data cannot be deleted.
This is the SQL - DELETE [CH Calls].*, [tbl RB Employees].Supervisor
FROM [CH Calls] INNER JOIN [tbl RB Employees] ON [CH Calls].Field2 = [tbl RB
Employees].[Login ID]
WHERE ((([tbl RB Employees].Supervisor) Like "moyer* or pilcher*" Or ([tbl
RB Employees].Supervisor) Like "range*"));
Where am I going wrong?
Thanks for any response.