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

Options: ReplyQuote


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.