Table Join
From: John Schaeffer <amerar_at_iwc.net>
Date: Tue, 14 Apr 2009 09:50:20 -0700 (PDT)
Message-ID: <0d69980f-19b9-481b-b025-7d80f8587578_at_l16g2000vba.googlegroups.com>
TICKER
CATEGORY_NAME
PERFORMANCE_RANK
TIME
TICKER
CATEGORY_NAME
PERFORMANCE_RANK
Date: Tue, 14 Apr 2009 09:50:20 -0700 (PDT)
Message-ID: <0d69980f-19b9-481b-b025-7d80f8587578_at_l16g2000vba.googlegroups.com>
Hi, I'm hoping that there is a slick way to do this.
I have 2 tables (below). They both have the same structure except for the first column. Is there a way to compare the tables and get the differences from TABLE A that are not in TABLE B, without having to use WHERE...AND...AND...AND for every column??
TABLE A
TICKER
CATEGORY_NAME
TOTAL_RETURN_1YR TOTAL_RETURN_6MO TOTAL_RETURN_3MO TOTAL_RETURN
PERFORMANCE_RANK
ORDINAL_1YR ORDINAL_6MO ORDINAL_3MO ORDINAL_RANK
TABLE B
TIME
TICKER
CATEGORY_NAME
TOTAL_RETURN_1YR TOTAL_RETURN_6MO TOTAL_RETURN_3MO TOTAL_RETURN
PERFORMANCE_RANK
ORDINAL_1YR ORDINAL_6MO ORDINAL_3MO ORDINAL_RANKReceived on Tue Apr 14 2009 - 11:50:20 CDT