Re: Table Join
From: ddf <oratune_at_msn.com>
Date: Tue, 14 Apr 2009 10:10:53 -0700 (PDT)
Message-ID: <e24b564c-4bf4-4016-a91e-aec5e4be2dc1_at_v28g2000vbb.googlegroups.com>
On Apr 14, 11:50 am, John Schaeffer <ame..._at_iwc.net> wrote:
> 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_RANK
You COULD try this:
PERFORMANCE_RANK,
from tablea
minus
select
TICKER,
CATEGORY_NAME,
PERFORMANCE_RANK,
from tableb;
Date: Tue, 14 Apr 2009 10:10:53 -0700 (PDT)
Message-ID: <e24b564c-4bf4-4016-a91e-aec5e4be2dc1_at_v28g2000vbb.googlegroups.com>
On Apr 14, 11:50 am, John Schaeffer <ame..._at_iwc.net> wrote:
> 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_RANK
You COULD try this:
select
TICKER,
CATEGORY_NAME,
TOTAL_RETURN_1YR, TOTAL_RETURN_6MO, TOTAL_RETURN_3MO, TOTAL_RETURN,
PERFORMANCE_RANK,
ORDINAL_1YR, ORDINAL_6MO, ORDINAL_3MO, ORDINAL_RANK
from tablea
minus
select
TICKER,
CATEGORY_NAME,
TOTAL_RETURN_1YR, TOTAL_RETURN_6MO, TOTAL_RETURN_3MO, TOTAL_RETURN,
PERFORMANCE_RANK,
ORDINAL_1YR, ORDINAL_6MO, ORDINAL_3MO, ORDINAL_RANK
from tableb;
Searching the newsgroup would have found similar solutions.
David Fitzjarrell Received on Tue Apr 14 2009 - 12:10:53 CDT