I think we need a spec..something like this
You want to report parcel numbers from file QS36F when
- a row with the same parcel number???? for year 2012 has roll_type R and Exclusion > 1
and??? / or????
- that row (or is this some other row) has Year 2013, Roll_type R and Exclusion < 1
 

I want a report of parcel numbers from QS36F that are missing the exclusion value from year 2012 to 2013. Both 2012 parcel numbers and exclusion value are stored in the same file with 2013 information.  I want it to compare 2012 vs 2013 and give me a list of parcel numbers that are missing the exclusion value from 2012 to 2013

Ok  .. almost there
Are you saying that you want
the parcel number of any rows that are 2013 and exclusion <> 1
Plus
the parcel number of any rows that are 2012 and exclusion <> 1
???

So now that I read it again .. you would be matching the 2012 and 2013 row on parcel number and if both had Exclusion <> 1??? then you want that row reported?

One simple way to “merge” two Selects is with the UNION, UNION ALL, INTERSECT, or EXCEPT keywords
This case sounds like an INTERSECT .. the value must appear in both lists.
http://www.itjungle.com/fhg/fhg071404-story01.html
 
 

I need a list of parcel numbers that had an exclusion in 2012 ( > 1) but the 2013 record exclusion field is < 1)

How do I tweek the above query to capture that information?  I’m really new to Iseries and query.  Thanks!

Then the Intersect (must be in both) should do the trick
Something like this
 
SELECT “T16.APAR”.P_PARCEL_NR
FROM QS36F.”T16.APAR” AS “T16.APAR”
WHERE “T16.APAR”.P_YEAR = 2012 AND
“T16.APAR”.P_ROLL_TYPE = ‘R’ AND
“T16.APAR”.P_EXCLUSION_VALUE > 1)
 
INTERSECT
 
(SELECT “T16.APAR”.P_PARCEL_NR
FROM QS36F.”T16.APAR” AS “T16.APAR”
WHERE “T16.APAR”.P_YEAR = 2013 AND
“T16.APAR”.P_ROLL_TYPE = ‘R’ AND
“T16.APAR”.P_EXCLUSION_VALUE < 1)

Thank you!