CyberShot Posted December 16, 2010 Share Posted December 16, 2010 I have three tables. two of my tables are linked to the names table with the namesID foreign key. So when I tried my query, I tried SELECT * FROM names, amounts, phone WHERE names.namesID = phone.nameID, amounts.nameID the idea is to return a name, phone number and amount owed from the tables. I am getting an error that says incorrect syntax near amounts.nameID Quote Link to comment https://forums.phpfreaks.com/topic/221845-how-to-perform-this-query/ 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.