access中的特殊運算符in與邏輯運算符or的區別？

沒有大區別借用上面例子a=1 or a =2 ==>可以寫為 a in (1, 2)唯一的區別應該在于in 可以跟子查詢select * from tabwhere dept in (select dept from tab where sno = '001')