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
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