I am trying to implement the following SQL in Linq. Table alias tm is a junction table between table t and table m SELECT t . Title , m . Publisher , t . Status , m . Type FROM Title_tab t , Title_Mkt_tab tm , Mkt_tab m WHERE t . Title_ID = tm . Tm_Title_ID AND m . Mkt_ID = tm . Tm_Mkt_ID The 3 tables have the following DataContext: private DataClasses1DataContext title = new DataClasses1DataContext (); private DataClasses1DataContext mkt = new DataClasses1DataContext (); private DataClasses1DataContext
Read More...