LEFT OUTER JOIN Using SQL Text Query Window in dbForge Studio. You can use the dbForge SQL text query editor to LEFT OUTER JOIN two or more tables. Click the “New SQL” button from the top left corner ...

I have a problem when I want to join the same table twice (once with object property and once with collection property) (the code is attached, with SQL script), EF generate an INNER JOIN for the ...