Unmatch Query

[RiesbeckP]

Hi,

My DB has the following fields:

Prod GL Prod CFO Amount
115 Term Life 004 20.00
116 Term Life 004 22.00
115 Term Life 005 15.00
115 Term Life 009 18.00
116 Term Life 009 21.00
115 Term Life 010 11.00
115 Term Life 015 16.00
116 Term Life 015 14.00

I want to be able to write a query that only return CFO 005 and CFO
010, since they do not have a corresponding record with a different
Prod, but same GL Prod. Does that make sense? I'm sure it's possible,
but can't figure out how to do it. Any help would be appreciated.
Thank you.

[Thats Me]

On 29 Mar 2006 12:40:28 -0800, "Ri*******@aetna.com"
<Ri*******@aetna.com> wrote:

Hi,

My DB has the following fields:

Prod GL Prod CFO Amount
115 Term Life 004 20.00
116 Term Life 004 22.00
115 Term Life 005 15.00
115 Term Life 009 18.00
116 Term Life 009 21.00
115 Term Life 010 11.00
115 Term Life 015 16.00
116 Term Life 015 14.00

I want to be able to write a query that only return CFO 005 and CFO
010, since they do not have a corresponding record with a different
Prod, but same GL Prod. Does that make sense? I'm sure it's possible,
but can't figure out how to do it. Any help would be appreciated.
Thank you.

try WHERE (((CFO)="005" Or (CFO)="010"))
Have a nice day. ld****@NOPANTS.juno.com

Remove NOPANTS. To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects

[RiesbeckP]

Thanks for your input, but I don't know which CFO's have only one
record. That is my problem.