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 Link to comment https://forums.phpfreaks.com/topic/221845-how-to-perform-this-query/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.