i have the following tables:
--------------
user_products
--------------
user_products_id
user_products_OFERTA_nume_produs
user_products_cod_produs
....

-----------
user_categ
-----------
user_categ_id
user_categ_parent_id
user_categ_nume
....

In ACCESS 2003 (working with MySQL tables) when i try to run the following query to make a report i get the error:
----------------------------------------
ERROR: Join expression not suported.
----------------------------------------

SELECT DISTINCTROW
"["+user_products.user_products_cod_produs+"] "+user_products.user_products_OFERTA_nume_prod us AS cod_produs, user_products.user_products_container_pret_magazin ,
user_categ.user_categ_nume
FROM user_products, user_categ
WHERE user_products.user_products_F_OFERTA=1
AND user_categ.user_categ_nume= (SELECT TOP 1 categ.user_categ_nume
FROM user_categ
LEFT JOIN user_categ AS categ
ON (user_categ.user_categ_parent_id=categ.user_categ_ id)
OR (user_categ.user_categ_parent_id=0 AND user_categ.user_categ_id=categ.user_categ_id)
WHERE user_categ.user_categ_id=user_products.user_catego ries_id);


When i import the tables into ACCESS and run the query it goes ok, and the report is fine.

Please tell me how do i make it work directly from MySQL (via ODBC) without spitting errors.