I have 2 tables set up. The first table is for events and the 2nd table is the dates of the events. One event can have many dates connected to it. Is there a way I can find the count of the event Id from the table that stores the actual event dates?
tbl_Event
EventId Guid
EventNotes varchar(255)
tbl_EventDateTime
EventId Guid
EventDateTime Date time
I want a query that will show everything in tbl_Event and then a column that shows the count of DateTimes in tbl_EventDateTime.
...
Go to the complete details ...