AND 和 OR 運算符用於基於一個以上的條件對記錄進行過濾。
AND 和 OR 運算符
LastName |
FirstName |
Address |
City |
Carter
Thomas
Changan Street
Beijing
OR 運算符實例
LastName |
FirstName |
Address |
City |
Carter
Thomas
Changan Street
Beijing
Carter
William
Xuanwumen 10
Beijing
結合 AND 和 OR 運算符
LastName |
FirstName |
Address |
City |
Carter
Thomas
Changan Street
Beijing
Carter
William
Xuanwumen 10
Beijing