If you take the following meetings for two companies:
MeetingID CompanyID Startdate EndDate CountryID StateID
M1 C1 2010-02-01 2010-02-01 2 10
M2 C1 2011-08-07 2011-08-07 20 5
M3 C2 2011-10-09 2011-10-09 2 10
For the first select statement the meetings M1 and M3 meet the criteria of the first
EXISTS
statement and meetings M2 and M3 meet the criteria of the second
EXISTS
statement. So companies C1 and C2 meet both
EXISTS
statements and are shown in the result.
Now in the second select statement meetings M1 and M2 do not meet the criteria of the single
EXISTS
statement and company C1 is not shown. Because meeting M3 does meet the criteria company C2 is shown in the result.