Information générale
Forum:
Microsoft SQL Server
Hi All:
I have a simple query. I have used this query successfuly in the past, however this time it is not working.
Here is the query
Select Meeting_ID
From Meetings
Where Not exists(select meeting_ID from Events)
It should returns 1,3,35, because the Ids in Meetings tables (1,3,35) are not in the Events table. Instead it returns 0 records.
What is wrong with my statement?
Please advise.
Thanks
MA
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement