Archives of the TeradataForum

Message Posted: Wed, 31 Dec 2008 @ 17:58:51 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Shijo:

You need to check the SELECT of the subquery. See how many columns are listed there. Then compare that with the number of columns listed before the IN. They should be the same. If not, you need to make sure they are the same as in 1:1, 2:2, 3:3, etc.

It is valid to have more than one, however the ones prior to the IN must be in parantheses:

     WHERE (column1, column2, column3)  IN  (SELECT col1, col2, col3 FROM ...)

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>