Thursday, September 27, 2012

Test MI, NJ


-- Gets all table name and column name of MI which are not in NJ

SELECT mi.tablename,mi.ColumnName, mi.tablename || mi.ColumnName
FROM MI
where mi.tablename || mi.ColumnName NOT IN
(
SELECT  nj.tablename || nj.columnname
FROM  NJ)
;

-- -- Gets all table name and column name of NJ  which are not in MI

SELECT nj.tablename,nj.ColumnName, nj.tablename || nj.ColumnName
FROM NJ
where nj.tablename || nj.ColumnName NOT IN
(
SELECT  mi.tablename || mi.columnname
FROM  mi)
;
 


-- || is used for concatenation

No comments: