Archives of the TeradataForum
Message Posted: Thu, 21 Jan 2010 @ 12:34:43 GMT
| Subj: || || Re: Workaround to avoid product join |
| From: || || Victor Sokovin |
| ||I am not sure if I can avoid joining the reference table only by extending the CASE though. I need the data to be grouped by every minute-
slice, while the main table stores just the ID of a starting and an ending minute. Maybe I miss something here, but I don't think it will be so
Not sure what exactly you need from the reference table but the logic you have described so far is easy enough to put it in one CASE and avoid
the join to the ref. table.