Supplied argument is not a valid MySQL

[Anon]

Hi .
I'm trying to paste some SQL code from MS-Access SQL to my running MySQL.
For some reason I get the following error
"Supplied argument is not a valid MySQL result resource" and I can't even exe this
query over the mysql console.
I run this query over MS Access with no special problem and tables layout are exactly the same.

I'm using mysql-3.22.23b

Here is the SQL dump from MS-Access

SELECT [users02].[Customer], [Region].[reg_id], [idata01].[sys_03]
FROM idata01 RIGHT JOIN (users02 INNER JOIN Region ON [users02].[Region_code]=[Region].[reg_id]) ON [idata01].[password]=[users02].[Password]
WHERE ((([Region].[reg_id])=2))

ORDER BY [users02].[Customer];

Thanks in advance
=TAnin

[stereo]

MS Access SQL and the SQL that is used with PHP are not the same. In PHP, a simple quesry would be something like....

mysql_query("SELECT * FROM (table name) WHERE (condition) = (conditaion);");

PHP uses special functions such as mysql_query(); mysql_fetch_array(); mysql_num_rows();

I suggest you learn these functions first.