Archives of the TeradataForum
Message Posted: Wed, 17 Feb 2010 @ 16:44:42 GMT
| Subj: || || Re: Help in joining tables |
| From: || || Ray, Andrew |
Your best bet is to load a new table with the cross reference information and join to it. if you are only talking about a few rows it could be
done with a case statement but it would not be the ideal solution. If you are hesitant to create an actual table then maybe you could create a
volatile temporary table which would be destroyed once you logoff your session.