Last active
October 18, 2015 08:53
-
-
Save wk-j/6ef3245bedf6a0fab195 to your computer and use it in GitHub Desktop.
Left outer join with LINQ.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select film.Title, fl.Id, fs.Id, it.Id, it.ThaiText from QFilms film | |
left outer join QFilmingLocations fl on film.Id = fl.QFilmId | |
left outer join QFilmingSupervisors fs on fl.Id = fs.QFilmingLocationId | |
left outer join QInstitutions it on fs.QInstitutionId = it.Id |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment