DB2//400 Query Manager

[Guest.Visitor]

How do you select unmatched records with Query Mangager (STRQM)?

[Guest.Visitor]

Try this... Select * from FileA exception join FileB on FileA.Field_X = FileB.Field_Y Will give you all the columns (*) in FileA for the Rows for which Field_X cannot be found in Field_Y

[Guest.Visitor]

Debbie, If you are still scratching your head, what you need to do is hit F19 once in the Work with Query menu. This will allow you to change your query selection from prompted (like Query/400) to SQL input like Bob has exampled.