Join where there is sometimes no value?
View Single Post
12-14-2012, 02:56 PM
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Thanked 2,598 Times in 2,567 Posts
Sure you can. Just use a LEFT JOIN to fetch all records from the primary table (governed by the where clause of course), and any matching records from the child table.
Users who have thanked Fou-Lu for this post:
View Public Profile
Find More Posts by Fou-Lu