Basic Question on joining 2 tables with an outer join
Posted on 2011-05-06
Please could someone help me get this join right. I Need All the rows of the list, and the matching rows of the Beacons - but for all my trying I only get matching rows... It is probably so simple but I can't see it.
Select B.[iKey] AS iKeyID, B.[iSeq], L.[cDisplay], L.[dFrom]
[iData].[dbo].[func_ListTable_Hour](NULL, 'hh', 1, '22 Apr 2011 16:00', '23 Apr 2011 06:00', 'F') L
JOIN [iTrail].[dbo].[BeaconUnitHit] B ON B.[dTo] BETWEEN L.[dFrom] And L.[dTo]