INNER JOIN DISTINCT with MySQL

I have a mysql problem. I have two tables like this that I need to join together.

table:

id otherid2

1 | 1

2 | 1

3 | 2

4 | 2

table2:

otherid otherid2

1 | 1

2 | 1

3 | 2

4 | 2

I'm using:

SELECT id,otheri开发者_运维问答d FROM table INNER JOIN table2 ON table.otherid2=table2.otherid2

This gives me:

id otherid

1 | 1

1 | 2

2 | 1

2 | 2

3 | 3

3 | 4

4 | 3

4 | 4

As you can see I get duplicates of id as there is otherid2s that is not unique in table2. What I need is to INNER JOIN DISTINCT in some way, I only want the result to be as below. Not duplicates.

This is what I want:

id otherid

1 | 1

2 | 1

3 | 3

4 | 3

Can I do this in an easy way?

---

If you want the row with the lowest id in table2, this should probably do it

SELECT id, min(otherid)
FROM table 
INNER JOIN table2 
ON table.otherid2=table2.otherid2
GROUP BY id

---

In your comment you wanted the lowest, then I'd suggest a group by and a min aggregator

SELECT id, MIN(otherid) AS otherid ... GROUP BY id