--as i've said, i did an explain and saw that
--part (where the error message says 'adding this to
--the FROM clause).
--i suspect that this was a typo, but since the
--person creating this isn't here now, i can not
--answer this.
--and i'm at the point where i *have* to kill the script.
--i just wanted to make sure that i wasn't just
--out on a witch hunt.
--thanks!
-X
-----Original Message-----
From: Peter Gibbs [mailto:peter@emkel.co.za]
Sent: Wednesday, April 02, 2003 9:22 AM
To: Johnson, Shaunn; pgsql (E-mail)
Subject: Re: [GENERAL] the results from a query - question
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