The reason I need to do this is long winded, so I wont emplain in to much
What I need is to create a table where comparing to contents of 2 other
identically structed tables and returning all the records that exist in
This is not difficult for my small tables with 5 columns
SELECT T1.col1, T1.col2, T1.col3, T1.col4, T1.col5
FROM T1, T2
WHERE T1.col1 = T2.col1 AND
T1.col2 = T2.col2 AND
T1.col3 = T2.col3 AND
T1.col4 = T2.col4 AND
T1.col5 = T2.col5
However, Two of my tables have in excess of 60 columns. I started on the
query, but thought there must be a better way.
Can anyone help?