| DISTINCT shouldn't be used for common queries as the previous poster mentioned.
I use it mostly for creating temporary tables to perform large operations on where I don't need repeating record information.
Too bad you're not using oracle.. PL/SQL developer is a great tool for gauging how efficient your queries are as well as learning to build better ones. (<3 cost analyzer).
__________________
Black Atom - Crescent of the Red Moon - Red Moon Federation  |