I have a query that cross joins a table of information against a table of dynamic dates that I create on the fly.
For some reason, when using IN, I cannot list multiple fields. It will run and not error if I only provide one list in the where clause:
So is this just a limitation of IN within Teradata? The OR solution works but the real query I'm writing has multiple IN statements already mixed with a bunch of OR and AND, so I was trying to keep the clutter down using IN.
I suppose I could just feed these values through a SP or something instead of trying to use the table. Other thought I had was creating a vertical dates table instead of horizontal and using a subquery against it. Any other thoughts?