To me it seems that using a join you should make use of matching columns between the two tables and in your example there is no such match.
Have a look at Help inner join, it shows the following example: ON t1.empid = t2.empid Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Croson Sent: maandag 17 mei 2010 15:05 To: RBASE-L Mailing List Subject: [RBASE-L] - Syntactically challenged? 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?
