illuzioner
Technical User
Hi,
what is the SQL syntax to do a self-join of a table to itself where the left table (tblLeft) pairs with the table on the right (tblRight) when
tblRight.Date = Max(tblRight.Date)
where tblRight.date < tblLeft.Date
tblLeft and tblRight are the same table. I'm guessing this is a Left Join instead of an Inner Join because I'm not matching fields from both tables.
Any help is greatly appreciated!
Lou
what is the SQL syntax to do a self-join of a table to itself where the left table (tblLeft) pairs with the table on the right (tblRight) when
tblRight.Date = Max(tblRight.Date)
where tblRight.date < tblLeft.Date
tblLeft and tblRight are the same table. I'm guessing this is a Left Join instead of an Inner Join because I'm not matching fields from both tables.
Any help is greatly appreciated!
Lou