Outer Join, 2 columns
Do I understand correctly that outer joins are used when only one column uniquely identifies rows? I have seen other posts on this forum and others on outer joins, but those posts address a situation where only one column uniquely identifies each row.
I need to copy all rows from tblA that are not in tblB, into tblB.
TblA and TblB have same structure.
Rows are made unique by two columns: DateTime, ID