Re: trouble figuring out joins, any gurus out there?
Posted by:
Mike M
Date: October 04, 2009 08:51PM
This seems to work, but there probably is an easier way to do it:
SELECT DISTINCT tag.value FROM tag, todo_tag WHERE tag.tag_id = todo_tag.tag_id AND todo_tag.todo_id IN (SELECT d.todo_id
FROM project_tag pt
JOIN project p ON p.project_id = pt.project_id
JOIN tag t ON pt.tag_id = t.tag_id
JOIN todo_tag dt ON dt.tag_id = pt.tag_id
JOIN todo d ON d.todo_id = dt.todo_id
WHERE pt.project_id = '1')
Subject
Written By
Posted
September 01, 2009 10:30PM
Re: trouble figuring out joins, any gurus out there?
October 04, 2009 08:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.