Help Me Tidy Up This Statement!

Hi All,

I have three select statements, which look like this:




Code Block

SELECT PhraseID, strPhrase FROM Phrase WHERE (LanguageID = ???)

I now want to display all of these columns side by side... The only way I've managed to do this is as follows:




Code Block

SELECT a.PhraseID, a.blah, b.blah, c.blah FROM
(SELECT PhraseID, strPhrase as blah FROM Phrase WHERE (LanguageID = 10)) a,
(SELECT PhraseID, strPhrase AS blah FROM Phrase WHERE (LanguageID = 15)) b,
(SELECT PhraseID, strPhrase AS blah FROM Phrase WHERE (LanguageID = 17)) c
WHERE a.PhraseID = b.PhraseID AND a.PhraseID = c.PhraseID
This looks like a bit of a kludgy way of doing it, and I'm sure I'm missing a trick!

Is there a better approach?

Thanks,
Neil