i need to join a list of values with real table, like
sel a1, a2, b2 from tab1 inner join (b1-1, b2-2 b1-2, b2-2 ) tab2 on a1=b1
My problem is the 'definition' of tab2. The 'normal' Teradata sql for tab2: select b1-1, b2-1 works fine - for only one pair of values. If i use union to have more than one pair of values, it needs a 'from' and a table name - because of the union. So i would need sg. like the DB2 sysdummy1 table - or another solution. I definitely can't create tab2 in the environment.