Re: the results from a query - question

--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(at)emkel(dot)co(dot)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