New in Databases

[FGL]

Hi everyone!

I have a problem converting a mysql query to an access 2007 query. I am getting the "Syntax error in Join Operation" message. I can't make the join work correctly.

Here is a generic format of the query

select t1.HI,t1.name,sum(me) as Me
from H t1 left join (I t2, J t3)
on (t1.HI=t2.HI and t2.ev=t3.ev
and t2.p=t3.p) group by t1.HI

Thanks!

 

[SimonB1978]

Hi,

I'd try this:

H t1 LEFT JOIN (I t2 INNER JOIN J t3 ON t2.ev = t3.ev AND t2.p = t3.p) ON t1.HI = t2.HI

Simon B.

 

[FGL]

Hi Simon b.

Thanks for the reply.
I did try it but it doesn't work.
However you gave me the idea and when I tried this:

from ((H t1 LEFT JOIN I t2 ON t1.HI = t2.HI)
LEFT JOIN J t3 ON (t2.p=t3.p) AND (t2.ev=t3.ev))

worked fine.

Thanks again