SQL error help

[fred_tededmondsson]

Hi, all,

Can someone spot what is wrong with this SQL query?

select mi.manufacturers_url from zen_manufacturers.m join zen_manufacturers_info.mi ON m.manufacturers_id = mi.manufacturers_id where m.manufacturers_name = 'Some Manufacturer'

I'm getting back an error that says:

1142 SELECT command denied to user myuser for table 'm'

TIA,
Fred

[Ajeh]

Try using:

select mi.manufacturers_url from zen_manufacturers m join zen_manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id where m.manufacturers_name = 'Some Manufacturer';

[fred_tededmondsson]

excellent, thanks, that got it. I had misread the syntax in the example I was basing my code off of.

[Ajeh]

Thanks for the update that this is now working for you ...