Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 22:09:07 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sorry for the late acknowledgement, but I wanted to thank all who responded to my question.

The obvious answer was "no", I cannot avoid a product join. The best suggestion was to create a "product id" and add that to the "Customer" table. That's something I can do (actually by building a separate "helper" table, since I can't change the original).

I was wondering, would something like this be possible/practical with a UDF? It seems like a natural fit for a function (send a code, do a lookup, return a result). I'm just asking. Most of my experience is with SAS and that's how I'd solve the problem.

Anyway, thanks very much for all the advice. As usual, I learned something new.

Bob

	<Prev	Next>		<<First	<Prev	Next>	Last>>