Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Query
Miscellaneous
Thread ID:
00957852
Message ID:
00957852
Views:
60
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
Next
Reply
Map
View

Click here to load this message in the networking platform