Tony, Thanks for responding, but there is a match. I'm using case#.
On 05/17/2010 09:04 AM, A.G. IJntema wrote: > 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? >
