Collation이 달라서 에러가 날때

에러 : Cannot resolve collation conflict for equal to operation

컬럼명 COLLATE "Collation 타입"

ex)

SELECT * FROM Data

WHERE MID COLLATE SQL_Latin1_General_CP1_CI_AS in (

SELECT MID FROM Data

)