SQL Query to convert single row from multiple tables into a single row in table??? : I have 7 tables with same structure. And each table has 2 columns,In these one column is join key( but not a primary key) and 2nd column is Unique.

Below is the requirement mentioned for 2 tables. But we need to develop for 7 tables.

TAB1:
=====
CITY    NAME
HYD     RAMU
HYD     KRISH


TAB1:
=====
CITY    NAME
HYD     RAJ
HYD     KRISH

OUTPUT:
=======

CITY   EXIST1   EXIST2
HYD     RAMU     NUKLL 
HYD     NULL     RAJ
HYD     KRISH    KRISH

PLEASE HELP ME TO DEVELOP QUERY ON THIS.