A well defined query against a well defined entity data model does not need JOIN . Navigation properties in combination with nesting sub-queries should be used instead. These latter constructs represent task requirements much more closely than JOIN does.