Difference between Access and MySQL

[plarts]

I migrate an application from Access to MySQL,
and then I have this error now :

SQL Syntax error in :

SELECT rubrique,* FROM dossier_tech
inner join rubrique on dossier_tech.dt_rubrique=rubrique.rub_id
where dt_id=270

It does run under Access,
MySql does not luike it ?

Thanks for any help.
Pierre.

[Brian Hogue]

Does MySQL support that Inner Join syntax?

-brian

"plarts" <pierre@pl-arts.com> wrote in message
news:d6at4g$qt1$1@forums.macromedia.com...

> I migrate an application from Access to MySQL,
> and then I have this error now :
>
> SQL Syntax error in :
>
> SELECT rubrique,* FROM dossier_tech
> inner join rubrique on dossier_tech.dt_rubrique=rubrique.rub_id
> where dt_id=270
>
> It does run under Access,
> MySql does not luike it ?
>
> Thanks for any help.
> Pierre.
>

[paross1]

I would be surprised that this actually worked in Access, but you might alter
your query per the example below. I am assuming that you wish to select the
rubrique column from the rubrique table, and all of the columns from the
dossier_tech table, where dt_rubrique equals rub_id:

SELECT r.rubrique, d.*
FROM dossier_tech d
INNER JOIN rubrique r ON d.dt_rubrique = r.rub_id
WHERE d.dt_id=270

Phil