MVSFORUMS.com

[karavi2000]

Hi,

I have a requirement.
I have 2 tables. Detail table and Error Table.
Records are stored in Detail table as

Id - Detail Sequence - Packet Sequence

100 - 1 - 1
100 - 2 - 2
100 - 3 - 2
100 - 4 - 2
100 - 5 - 5
100 - 6 - 5
100 - 7 - 5
.
.
.
If any of the above records are in error, the Error table will contian

Id - Detail Seqence - Err-Code
100 - 2 - 4002
100 - 3 - 4002
100 - 3 - 4006
100 - 5 - 4007
.
.

My requirement here is, if I have a Id and Detail Sequence, I would like to know if any of the records corresponding to that Packet-Sequence are in Error.

For Eg. say I have Id as 100 and Detail-Sequence as 2. The Packet-Sequence is 2 for the record which has Detail-sequence as 2. The Packet-Sequence is also 2 for the records which has Detail-Sequence as 3 and 4. I would like to have a query which gives me the Id Err-Code from Error-table corresponding to that packet (i.e., For Detail Sequence numbers 2, 3, 4) joining Detail and Error table in a Single query.

Am I clear with the requirement? Please give me a solution.

Thanks & Regards,
Ravishankar

[kolusu]

Ravishankar,

Unless I am missing something , it is very easy query(I did not test it)