otuatail Posted July 22, 2015 Share Posted July 22, 2015 SELECT EntryDate, Input, Output, Comment, Tag, Bank_Reason.Reason AS Reason FROM Bank_Data.Reason INNER JOIN Bank_Reason.ReasonID WHERE Tag = '55ad7d70397665cdf6bd175bcf55eda83d45feb96'; #1142 - SELECT command denied to user 'otookr692'@'10.3.4.92' for table 'Reason' DROP TABLE IF EXISTS `Bank_Data`; CREATE TABLE IF NOT EXISTS `Bank_Data` ( `EntryDate` date DEFAULT NULL, `Input` decimal(6,2) NOT NULL DEFAULT '0.00', `Output` decimal(6,2) NOT NULL DEFAULT '0.00', `Reason` tinyint(1) NOT NULL DEFAULT '0', `Comment` varchar(32) NOT NULL DEFAULT '', `Tag` varchar(45) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `Bank_Reason`; CREATE TABLE IF NOT EXISTS `Bank_Reason` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ReasonID` tinyint(1), `Reason` varchar(10) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I have 2 table Bank_Data and Bank_Reason. I can do a select on both in phpmyadmin. The following query fails with a kind of access denied statement Quote Link to comment https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/ Share on other sites More sharing options...
Solution otuatail Posted July 22, 2015 Author Solution Share Posted July 22, 2015 Sorry cancel that. Must have had a mental breakdown. Quote Link to comment https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/#findComment-1517051 Share on other sites More sharing options...
otuatail Posted July 22, 2015 Author Share Posted July 22, 2015 How do I mark it as answered? Quote Link to comment https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/#findComment-1517052 Share on other sites More sharing options...
cyberRobot Posted July 22, 2015 Share Posted July 22, 2015 I marked the topic has solved. For future reference, there is a "Mark Solved" button in lower-right hand corner of each reply box. You would of course click the button that correspondences with the reply that mostly closely answers the question(s). Quote Link to comment https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/#findComment-1517060 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.