MVSFORUMS.com

rajeev5174 · Beginner Joined: 05 Jun 2007 Posts: 25 Topics: 10

Hello

Could someone let me know how best we can get the resultset

We have 3 table T1 T2 & T3 we need to find out those (empno) records which are there in t1 and not there in t2 and then join this with a 3'rd table

t3 on empno & select the statuscd 'T" and 'I'

Table column are as below-( Empno is PK for the below 3 tables)

T1 fields

kolusu · Posted: Wed Jun 27, 2012 12:38 pm Post subject:

rajeev5174,

How many topics are you going to create with the same title "SQL Query" ? Can't you provide descriptive titles? Use meaningful topics (don't use the Forum name for the topic). Use a descriptive Title to explain your problem. Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.

And how is this new query any different from the one you posted earlier? except for the PO_NBR to Empno now?

http://www.mvsforums.com/helpboards/viewtopic.php?t=12004

Kolusu