Query : Real query Intersect and Except in Mysql Server or Oracle

query Intersect in mysql same with query IN
and Except in mysql same with query NOT IN


Intersect ( Irisan )

SELECT supplier_id
FROM suppliers
WHERE supplier_id <= 99
INTERSECT
SELECT supplier_id
FROM orders
WHERE quantity > 25;

oTHER

Select City From Customers
Intersect
Select City From Sales
 

Except

SELECT supplier_id
FROM suppliers
WHERE supplier_id <= 99
EXCEPT
SELECT supplier_id
FROM orders
WHERE quantity > 25; 

oTHER

Select City From Customers
Except
Select City From Sales