Re: Does a normalized design lead to complex queries?
Posted by:
Bob Field
Date: October 16, 2006 06:19PM
That is actually not all that complex of a query. I find that coding statements using the new ANSI syntax makes for more readable queries, helps to make visible the structure of the query, and simplifies extending it. For example, your query recoded:
SELECT DISTINCT c.name
FROM languages AS l
JOIN candidates AS c ON l.candidateid = c.candidateid
JOIN skills AS s ON s.candidateid = c.candidateid
WHERE s.skillname IN ('php', 'asp')
AND l.languagename IN ('FR', 'EN')
GROUP BY c.name
HAVING count(DISTINCT s.skillid) = 2
AND count(DISTINCT l.languageid) = 2
Subject
Written By
Posted
Re: Does a normalized design lead to complex queries?
October 16, 2006 06:19PM
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.