The simplest solution is a join with USING instead of ON. That way, the database "knows" that both id columns are actually the same, and won't nitpick on that: SELECT id, name, section. FROM tbl_names. JOIN tbl_section USING (id) If id is the only common column name in tbl_names and tbl_section, you can even use a NATURAL JOIN: SELECT id, name ... More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.