MVSFORUMS.com

[sanjayr321]

Hai all,

My input table look like

Customer-Table(Cust-No, Acct-No)

A 0003
A 0006
A 0005
A 0002

Account-Table (Acct-No)

0001
0004
0003

Now my requirement is

Condition 1

For one customer all the accounts in the customer table should match with accounts in the account table i.e. if customer table having

A 0004
A 0003
A 0005

then the account table aslo have

0004
0005
0003

exact to the accounts present in the customer table, if satisfies above condition then write the customer details to o/p file

Condition 2

If one of the accounts on the customer table does not match with the any of the accounts on the account table i.e. if customer table having

A 0004
A 0003
A 0005

and account table having

0004
0006
0002

Then in the report i have to write the customer details for the account number 0003 and 0005 since it not present in the account table.

Please help me out on this logic...

Thanks in advance..

[kolusu]

sanjayr321,

Is this a part of your home work? You have opened 4 topics and all of them deal with similar problem. Show us what you have tried and we will try to help

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu