Re: Simple SQL Question

> Sorry, my bad. I should have left the part in the original message that
> asked how to do this without using UNIONs.

Me too. I should have gone back to the original message before replying :-). Pavan has a good suggestion, but I have to wonder if the overhead (in terms of run-time performance as well as understanding the code for maintenance purposes) is really any better than dealing with unions. You'll just have to try it and see. Ultimately, proper table design solves all of these things. Yeah, I know you don't want to change the table, but you can't always have your cake and eat it too . . .

• Beth