Re: Creating virtual keys to join by

nknight62_at_yahoo.com wrote:
> I am always needing to do something like this, but can't seem to find
> the right approach:

<snipped>

The right approach would be to tell the "designers" of that table/system to slowy extract their heads from their backsides (in order not to hurt themselves even more), and stop violating fundemental relational design principles.

A column must contain an atomic value. Period.

Alternatively, you can simply use a lead pipe and beat the crap out of them and their design.

Personnaly, as a Scorched Earth Party supporter*, I prefer the latter approach myself.

--
Billy

* Scorched Earth Party supporters firmly believe that there is no
problem that is so complex, difficult and delicate, that cannot be
solved with the carefull and dedicated application of bloody and
mindless voilence. Using lead pipes of course.