get everything from table A that is not in table B
- From: dufffman@xxxxxxxxx
- Date: 22 Dec 2005 05:35:52 -0800
Hi,
I have a table Rates(date,maturity,rate) in which are downloaded rates
for different maturity points, say 1YR, 2YR, 3YR and so on. I wish to
write a query that would provide me if there were more or less maturity
points downloaded between two days.
So lets say on day1 I downloaded
1 YR -> 100
2 YR -> 200
3 YR -> 300
and on day2 I downloaded
2YR -> 200
3YR -> 300
4YR -> 400
at the end, the query should produce two results (the rates themselves
are not too important)
Result1 -> "Exists in Day1 but not in Day 2"
1YR
Result2 -> "Exists in Day2 but not in Day1"
4YR
What is the best way to write this query?
Thanks.
.
- Follow-Ups:
- Re: get everything from table A that is not in table B
- From: dufffman
- Re: get everything from table A that is not in table B
- Prev by Date: Re: GUI tool for sybase
- Next by Date: Re: Sybase error -5702 and -1
- Previous by thread: GUI tool for sybase
- Next by thread: Re: get everything from table A that is not in table B
- Index(es):
Relevant Pages
|
