A question about joins...

[Mayoor]

I am joining 3 tables together although when there are no matching results in the contributor table nothing is retuned for the whole record set.

I would like the firstname and lastname to just say null if there is nothing in them. Can anyone help?

SELECT 
	E.EventID, 
	E.Title, 
	E.BriefDescription, 
	E.Description, 
	E.ThumbnailImageID, 
	E.ImageID, 
	E.StartDateTime, 
	E.EndDateTime, 
	E.Cost, 
	E.EventTypeID, 
	E.isAdults, 
	E.isChildren, 
	E.InsertedBy, 
	E.InsertedDate,
	C.FirstName,
	C.LastName

FROM 
	Event AS E

LEFT JOIN 	
	EventContributor AS EC
ON	EC.EventID = E.EventID	

LEFT JOIN 	
	Contributor AS C
ON	EC.ContributorID = C.ContributorID

WHERE 	EC.EventID = 3

 

[JamesLean]

Change your query to use:

WHERE E.EventID = 3

--James

 

[Mayoor]

Sorry I forgot to mention that that is usually parameter driven I have substituted 3 in just for test purposes.

Incidently there are 5 records in the Event table but only one record in the EventContributor table which matches.

There may not necessarily be a contributor for an event.

My aim is to output the event and any contributors (firstname and lastname) if there are any, if not then just want thhe firstname and lastname fields to have null in them.

Thanks!

 

[Mayoor]

well bugger me its fixed! Thanks James!