I want to use multiple columns, (where..in), such as “select * from Table1 where Col1, Col2 IN (select Col1, Col2 from Table2). I know I can concatenate as in “..from Table1 where Col1&Col2 in (select Col1&Col2 from Sales) but that may not work in some circumstances. And it’s kind of kludgey.
New contributor
JohnG is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1