lgalumbres
New member
- Local time
- Today, 15:10
- Joined
- Oct 19, 2004
- Messages
- 5
Hello everyone,
I have two tables, Reinvests and Trades:
Reinvests table has the following fields:
- Portfolio Code
- Tran Code
- Security Symbol
- Trade Date
- Settle Date
- Quantity
- Amount
- mgr#
Trades table has the following fields:
- Portfolio Code - Start Date
- Tran Code
- Sec Type Code
- Security Symbol
- Trade Date
- Settle Date
- Quantity
- Amount
- mgr#
- FA#
- prgm
I basically need to create a query that only produce records where only records are returned for which do not have a matching "dv" Trans Code vs. "by" Trans Code. For example, IF dv.account=by.account AND IF dv.tradedate=by.tradedate AND IF dv.symbol=by.symbol THEN its ignored for the data collection.
Any help would be great... thanks......
I have two tables, Reinvests and Trades:
Reinvests table has the following fields:
- Portfolio Code
- Tran Code
- Security Symbol
- Trade Date
- Settle Date
- Quantity
- Amount
- mgr#
Trades table has the following fields:
- Portfolio Code - Start Date
- Tran Code
- Sec Type Code
- Security Symbol
- Trade Date
- Settle Date
- Quantity
- Amount
- mgr#
- FA#
- prgm
I basically need to create a query that only produce records where only records are returned for which do not have a matching "dv" Trans Code vs. "by" Trans Code. For example, IF dv.account=by.account AND IF dv.tradedate=by.tradedate AND IF dv.symbol=by.symbol THEN its ignored for the data collection.
Any help would be great... thanks......