database - SQL Server: How to do an unmatched query using two SELECT statements -

i have following 2 queries want combine , mismatched results of combination 'zone_type-building_type'

first sql query

select zone_type, building_type area zone_type=2 

second sql query

select zone_type, building_type region building_type='a' 

i want find out of 'zone type-building type' combinations in first sql query not in second...and vice versa. note i'm looking combination of 2 , not separate zone or building types. example if zone type 5 , building type xyz want '5xyz' in 1 query result not in other. using ms sql server 2008

thanks lot!

here solution:

select zone_type, building_type area zone_type=2 except select zone_type, building_type region building_type='a' 

second query

select zone_type, building_type region building_type='a' except select zone_type, building_type area zone_type=2