例如:select * from mapuserrwhere useridin(101,102,103,104)
ON主要用於連接兩個表。
比如:
selectdistinctcustomers . customerid,fromcustomersjoinorderson
(客戶.客戶=訂單.客戶id
)
whereorders.shippeddate