Use Of Not Exist Clause Is Not Giving Satisfying Results

Asked By 10 points N/A Posted on -
qa-featured

Hi,

I have to fix a program error, which should find those entries in table1 which do not have matching records in table2 and then insert records in table2, so that for each record in table1 there should be at least one corresponding match in table2.

First I am trying to return IDs in table1, which do not have a corresponding match in the second table and then want to insert. Below is the query which is not working as per expectation:

INSERT into Services(Services.FkLobbyId, Services.FkServiceId, Services.ServiceTime)
values (LobbyId, '26','1')
(Select LobbyId FROM Lobby WHERE (NOT EXISTS (SELECT FkLobbyId FROM ServiceProvided WHERE (Lobby.LobbyId = FkLobbyId))))

Thank you.

SHARE
Answered By 0 points N/A #129304

Use Of Not Exist Clause Is Not Giving Satisfying Results

qa-featured

INSERT into Services(Services.FkLobbyId, Services.FkServiceId, Services.ServiceTime)
values (LobbyId, '26','1')
(Select LobbyId FROM Lobby WHERE (NOT EXISTS (SELECT FkLobbyId FROM ServiceProvided WHERE (Lobby.LobbyId = FkLobbyId))))

This query is wrongly written therefore an error message is being displayed.

The correct query is as follows:

INSERT into Services(Services.FkLobbyId, Services.FkServiceId, Services.ServiceTime)
values (LobbyId=(Select LobbyId FROM Lobby WHERE LobbyId NOT in (SELECT FkLobbyId FROM ServiceProvided )), '26','1') )

Hope your problem will be solved after applying this query.

Regards.

Login/Register to Answer

Related Questions