You Should Never Use IN In SQL To JOIN With Another Table

Do you use the following syntax? SELECT * FROM TABLE WHERE CoLumn IN (SELECT CoLumn FROM TABLE) Do NOT use that it can cause big problems if you do not understand exactly how IN and NOT IN works