Entity SQL Tip #1
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. That makes it easier to build and maintain correct Entity SQL queries.