Company1과 Company2라는 데이터가 들어간 테이블을 생성한다.
select * into Company1
from (
values ('Bohler Uddeholm Spec Metals','South Boston','VA')
,('Cigital Inc','Sterling','VA')
,('Texas Citrus Exchange','Mission','TX')
,('Garden State Tanning Byron WD','Williamsport','MD')
,('Byram Realty','Lexington','GA')
,('Blue Moon Graphics','Charleston','SC')
,('Lake Tahoe Community College','South Lake Tahoe','CA')
,('Pyramind','San Francisco','CA')
,('Twisp Chamber Of Commerce','Twisp','WA')
,('Dalsin Industries','Bloomington','MN')) Tab (comname, city, state)
select * into Company2
from (
values ('Bohler Uddeholm Spec Metals','South Boston','VA')
,('Cigital Inc','Sterling','VA')
,('Texas Citrus Exchange','Mission','TX')
,('Blue Moon Graphics','Charleston','SC')
,('Lake Tahoe Community College','South Lake Tahoe','CA')
,('Pyramind','San Francisco','CA')
,('Twisp Chamber Of Commerce','Twisp','WA')
,('Dalsin Industries','Bloomington','MN')
,('A Beautiful Celebration','Leesburg','FL')
,('Bumper To Bumper','Valley','AL')
,('Alpha Graphics','Baton Rouge','LA')
,('ARH Air Cond Refrig & Heat','Wewahitchka','FL')
,('Bama Golf Carts','Sylacauga','AL')
,('Baggett Consulting','Fairhope','AL')
,('Byrd''s Western Store','Melbourne','FL')
,('Byrd Tile Distributors','Raleigh','NC')
,('Ronald Mc Donald House','Columbus','OH')) Tab (comname, city, state)
1. intersect
select comname, city, state
from Company1
intersect
select comname, city, state from Company2;
intersect 결과
2. inner join
select * from company1
inner join Company2
on Company1.comname = Company2.comname;
inner join 결과
