I have two tables:
All of the fields in the Projects table, except ProjectID, are foreign keys to the PeopleID in the People table. I need to construct a query that will pull the PeopleID, Name, and E-Mail of the Leader and all four Participants, based on a Project ID. Something like this:
FROM People, Projects
WHERE ProjectID = 1234
It's possible (and likely) that some of the ParticipantIDs will be NULL.
What's the best way to construct this query?
I'm using SQL Server 2005, if that makes any difference to the query.