Re: Exception Report
In <2631@abcom.ATT.COM> 3030 writes:
}I need help with an INFORMIX ace report.
}
}I have a table which contains raw data and a table which contains valid
}values for one of the columns column.
}
}What I need to be able to do is be able to identify all rows which do not
}have a corresponding value in my look up table (i.e. exception report).
}
}
} realize that this is probable trivial but I am having trouble figuring
}this out since I am new to Informix.
}
}Thank for your help.
It sounds to me like you're asking for a list of all the rows in the
raw data table that do not have entries in the table containing
valid values. Based on this assumption, here is a solution to your
problem:
Given the tables raw_tbl(keyfld, codefld1, codefld2, ...) and
valid_tbl(keyfld, ...) you can find all the rows in raw_tbl that do
not have entries in the table valid_tbl with the select:
select * from raw_tbl
where keyfld not in (select keyfld from valid_tbl);
Hope this helps,
jeffl
----
Jeffrey F. Lawhorn American TriTech/ISG
Programming Manager C, C++, and Database Consulting
jeffl@isg.com 450 B Street 16th Floor
sdsu!isg100!jeffl San Diego, CA 92101 (619) 234-3405 x274