Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2008 @ 22:09:07 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|