EXCEPT 與 INTERSECT 實例

適用:SQL 2000,2005,2008
--
select prod_bar from A where promo_id='543'
EXCEPT
select prod_bar from B where promo_id='543'

select prod_bar from A where promo_id='543'
INTERSECT
select prod_bar from B where promo_id='543'

--