Skip to content

Instantly share code, notes, and snippets.

@wk-j
Last active October 18, 2015 08:53
Show Gist options
  • Save wk-j/6ef3245bedf6a0fab195 to your computer and use it in GitHub Desktop.
Save wk-j/6ef3245bedf6a0fab195 to your computer and use it in GitHub Desktop.
Left outer join with LINQ.
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