Posted by manstein on 12/29/05 00:17
Hello Danielle
"The reason for the join is that I need to know if a.tran_date =
c.holiday_date and holidays differ by GEO."
Im not sure what you want since this is a bit cryptic but is this code
similar to what you need?
select distinct
a.col1,
b.col1
from a
inner join b on b.id = a.id
inner join c on c.holiday_date= a.tran_date
where b.geo<>c.geo;
Also, you showed some concern about the number of rows returned. Use
"distinct" keyword to get unique records and a more concise number of
rows.
best regards
Navigation:
[Reply to this message]
|