the results from a query - questionShaunn Johnson wrote:
<rest of query snipped>
db2_gm_reg_prof_01.diagnosis_cd not like '314%' and
db2_gm_reg_prof_01.diagnosis_cd not like '315%' and
db2_pos_reg_prof_01.diagnosis_cd not like '316%'
^^^^^^^^^^^^^^^^^^
Did you really mean to refer to a different table on the last where clause?
Regards
Peter Gibbs
EmKel Systems