Re: Simple SQL Question

The tagline from an old Fram commercial for oil filters applies when talking about working around a bad table design:

"Pay me now or pay me later."

If you don't fix the table, you'll be working around it forever. Then the day will come that you need something done very quickly ...

Greg

On Tue, 20 Feb 2001 12:51:10 -0500, Beth Katcher <b.katcher_at_rcn.com> wrote:

>> 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
Received on Sun Mar 25 2001 - 14:37:57 CST