I have two tables in my database. Men table:
x
+----------------------------------------
| ID | menname | partner |
+----------------------------------------
| 1 | Mark | 1 |
| 2 | Adam | 2 |
----------------------------------------+
Women table:
+---------------------------------------+
| ID | womenname |
+---------------------------------------+
| 1 | Lisa |
| 2 | Emma |
+---------------------------------------+
When I do a inner join, I get:
+----------------------------------------
| ID | menname | partner |
+----------------------------------------
| 1 | Mark | 1 |
| 2 | Adam | 2 |
----------------------------------------+
instead of:
+----------------------------------------
| ID | menname | partner |
+----------------------------------------
| 1 | Mark | Lisa |
| 2 | Adam | Emma |
----------------------------------------+
It gets the id, instead of the partner name. Anyone know what is wrong with my query?
Advertisement
Answer
SELECT m.ID
,m.menname
,w.womenname AS partner
FROM Men AS m
INNER JOIN Women AS w ON m.partner = w.ID;