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?

