|
Hi Everyone,
I have a question regarding a SQL Query. I am new to Sql programming.
my query is:
SELECT
M.MeetingCode,
M.City AS MeetingCity,
M.State AS MeetingState,
Count(*) as NoofRSVP
FROM
Programs P
INNER JOIN eCDReservations M ON (P.SubCompanyCode = M.SubCompanyCode AND P.ProgramCode = M.ProgramCode)
LEFT JOIN MeetingAttendees MA ON (M.ReservationID = MA.MeetingID)
INNER JOIN Attendees A ON (MA.AttendeeID = A.AttendeeID)
WHERE
P.SubCompanyCode = 'A011' AND
P.ProgramCode = 'ACL52B'
GROUP BY
M.MeetingCode,
M.City,
M.State
if I run it i get 2 rows.
But if run following query:
SELECT
M.MeetingCode,
M.City AS MeetingCity
from
Programs P, eCDReservations M
WHERE
P.SubCompanyCode = M.SubCompanyCode AND
P.ProgramCode = M.ProgramCode AND
P.SubCompanyCode = 'A011' AND
P.ProgramCode = 'ACL52B'
order by
M.City,
M.State
I get 4 rows. I want all these 4 rows appear in first query result with NoofRSVP = either 0 or null if there is no matching MeetingID in MeetingAttendees table.
|
