54. [SQL]IN/NOT IN/EXISTS/NOT EXISTS的替代写法

54.1. LEFT SEMI JOIN

54.2. LEFT ANTI JOIN

54.3. WHERE ()=1