hello

i have the following query which works great on an ACCESS database (tables from MySQL imported, via ODBC):

SELECT DISTINCTROW
"["+user_brands.user_brands_nume+" "+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,
user_brands.user_brands_nume

FROM user_categ, user_brands

INNER JOIN user_products
ON user_brands.user_brands_id=user_products.user_bran ds_id

WHERE (((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))
AND ((user_products.user_products_F_OFERTA)=1))
ORDER BY user_products.user_products_container_pret_magazin ;


When i use this query with linked tables (from MySQL), the error message is:
-------------------------------------
ERROR: Join Expression Not Supported
-------------------------------------

I am using ACCESS2k and the tables are linked from MySQL 4.0.21

Can someone tell me why i got that error message. Thanks!