drummer101 Posted November 30, 2008 Share Posted November 30, 2008 So I've got one table bans that contains, username, date, ban_mod and another table that contains id, username How can I select everything from table one, and the username from table2 where it matches the ban_mod on table1? Link to comment https://forums.phpfreaks.com/topic/134852-selecting-from-multiple-tables-join/ Share on other sites More sharing options...
Mchl Posted November 30, 2008 Share Posted November 30, 2008 SELECT table1.*, table2.username FROM table1 INNER JOIN table2 USING username Link to comment https://forums.phpfreaks.com/topic/134852-selecting-from-multiple-tables-join/#findComment-702180 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.