Checking multiple columns using "IN"
551174Feb 13 2007 — edited Feb 13 2007I have a query
select 1 from tableA
where
cond1 = val1 and
exists
( col1, col2, col3, col4 ) IN
( select
cola, colb, colc, cold
from
table B
where
cond1 = val1
)
Will this condition Checking for multiple columns in the IN work ?
I actually mispelled a column name ( say colb ) in the sub query but it did not give a error, but executed fine by matching part of the columns alone?