MVSFORUMS.com

[Novice]

I have a following table where owners and accounts are stored. Owner ID and A/C no is the Primary Key.

[kolusu]

[Novice]

Kolusu,

Thanks for your reply and time.

This query is a part of a process, where in I will get specific owners and I need to find the associated Joint account existence.

As per my current process, due to my query I will get both A1 and A5, then I will pick up each account and will go to table again and pick up the owners and compare them with my input owners.

For example if my process gives me Owner Id as O4 and O5, here are my steps

1) Run above Query - Store result in a table ( 2 in this case)
2) Perform Result till end of table
a) Pick up 1st result i.e., Account No , go to table and get owners - This will return O1 and O2.
b) Compare these owners with my input owner Id's O4 and O5, they are not same, then ignore and go to next account.
c) For the next account , go to table and get the owners - This will return O4 and O5.
d) Compare these owners with my input O4 and O5, they are same, and there is an existence of Joint account for these owners and stop the above loop.

Please note even though two owners can have multiple accounts, I am interested only one of them (Like in the above example if O1 and O2 also own A6, I am interested to know whether there is a joint account exists or not for O1 and O2)

Thanks Once again
Novice

[sriramla]

Try this untested code: