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 Link to comment https://forums.phpfreaks.com/topic/297417-access-denied-on-sql-query/ Share on other sites More sharing options...
otuatail Posted July 22, 2015 Author Share Posted July 22, 2015 Sorry cancel that. Must have had a mental breakdown. 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? 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). 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
Archived
This topic is now archived and is closed to further replies.