Inner Join Help

Nov 21, 2013 at 9:50 PM
How do I translate the following SQL in linq.js?
SELECT  
    t1.C611_ID, t1.C611_ISBN, 'Start and End Date', 'Start and End Date Overlap Existing Record'  
FROM 
    dbo.Table1 t1
INNER JOIN  
    dbo.Table2 t2 ON t1.C611_ISBN = t2.C611_ISBN
WHERE 
    t1.C611_ID <> t2.C611_ID AND
    (t1.C611_DateStart BETWEEN t2.C611_DateStart AND t2.C611_DateEnd OR
    t1.C611_DateEnd BETWEEN t2.C611_DateStart AND t2.C611_DateEnd OR
    t1.C611_DateStart <= t2.C611_DateStart AND t1.C611_DateEnd >= t2.C611_DateEnd)
Feb 27, 2014 at 7:23 PM
I 2 would like to see some join examples (examples on everything would be good!)