delete Services from Services S inner join [RB/Services] RBS on RBS.ServiceId = S.ServiceId join Recreation_Bases RB on RBS.RBId = RB.RBId where RB.Location = 'Rivne';

And this also does not work:

 delete from Services where Services.ServiceId in (select Services.ServiceId from Services join [RB/Services] on [RB/Services].ServiceId = Services.ServiceId join Recreation_Bases on [RB/Services].RBId = Recreation_Bases.RBId where Recreation_Bases.Location = 'Rivne');

What is wrong and how to fix it?

    1 answer 1

    It looks like you are trying to execute a query from under SQL Server in MySQL.