View Full Version : join syntax for table.column
12-06-2011, 05:24 AM
I'm trying to join a couple tables that have the same column name. I want to do something like:
JOIN continents.Name AS continentname ON table1.continents = continents.ID
But I'm getting an error:
command denied to user 'username'@'localhost' for table 'Name'
Is this not a possible way of doing my query?
12-06-2011, 06:09 PM
You really don't say what you want from the two tables. This one produces only the set of records that match in both Table1 and name.
SELECT * FROM Table1
INNER JOIN Name
ON table1.continents = Name.continents
12-06-2011, 09:38 PM
Why do you think MySQL would lie to you about the error??
That error surely means exactly what it says.
The default user (username@localhost) simply doesn't have permission to access that table in that database.
To find out for sure, just try getting something from that table, without using a JOIN.
You should get the same message.
So now you need to go add username@localhost as an account with permissions to that database and/or table.
Powered by vBulletin® Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. All rights reserved.