[SQL] Select from 3 identical tables?

I rarely create complex sqls and ain't done a join for years.

I can get two tables to join, but not 3.

+rep to any help :)

Can you expand on what you want?

Wouldnt you use the distinct? Havent used it personally but I think you need to use that :)

Lew.

So far I have:

Code:

---

SELECT comments.id FROM comments c INNER JOIN group_comments g ON c.id = g.id JOIN photo_comments p ON g.id = p.id

---

But that ain't working

I prefer to stick to simple sql commands if poss lol. But I think it wud be work checking out the distinct command?

Lew.

Quote:

---

Originally Posted by Moh

So far I have:

Code:

---

SELECT comments.id FROM comments c INNER JOIN group_comments g ON c.id = g.id JOIN photo_comments p ON g.id = p.id

---

But that ain't working

---

Try this

Code:

---

SELECT * FROM ( comments LEFT JOIN group_comments ON comments.id = group_comments.id ) LEFT JOIN photo_comments ON group_comments.id = photo_comments.id

---

Quote:

---

Originally Posted by Blob

Try this

Code:

---

SELECT * FROM ( comments LEFT JOIN group_comments ON comments.id = group_comments.id ) LEFT JOIN photo_comments ON group_comments.id = photo_comments.id

---

---

Tried that too =[

In the end i just used UNION :)