title: SQL JOIN vs IN performance?
body: <p>I have a case where using a JOIN or an IN will give me the correct results...  Which typically has better performance and why?  How much does it depend on what database server you are running?  (FYI I am using MSSQL)</p>