I'm challenged by this, because I think it should work:

SELECT P.inj_code FROM patient P INNER JOIN pri_ins I on P.case#=I.case#
WHERE P.inj_code = '04' AND I.i_num = '01'

This renders an -ERROR- Syntax is incorrect for the command SELECT [2045]

Huh? Isn't this a correct statement?


Reply via email to