DROP TABLE ctDD;
CREATE TABLE ctDD
(	
  TableName VARCHAR(50),
  ColumnName VARCHAR(50),
  ColumnType VARCHAR(10)
);
DROP TABLE Zones;
CREATE Table Zones
(
  Zones VARCHAR(10),
  ZoneName VARCHAR(50)
);
CREATE TABLE Users
(
  UserName VARCHAR(25),
  StartDate DATE,
  EndDate DATE,
  GroupName VARCHAR(10)
);
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Zones', 'Zone');
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Zones', 'ZoneName');
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Users', 'UserName');
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Users', 'StartDate');
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Users', 'EndDate');
INSERT INTO ctDD (TableName, ColumnName) VALUES ('Users', 'GroupName');

SELECT ctDD.ColumnName, ctDD.ColumnType
FROM ctnova_com_celltracker.ctDD 
WHERE ctDD.TableName='Zones' 
AND CONCAT(ctDD.TableName, '.', ctDD.ColumnName) NOT IN (SELECT CONCAT(Table_Name, '.', Column_Name) FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name='Zones') 
ORDER BY ColumnName;

SELECT ctDD.ColumnName, ctDD.ColumnType
FROM ctnova_com_celltracker.ctDD 
WHERE ctDD.TableName='Users' 
AND CONCAT(ctDD.TableName, '.', ctDD.ColumnName) NOT IN (SELECT CONCAT(Table_Name, '.', Column_Name) FROM INFORMATION_SCHEMA.COLUMNS WHERE Table_Name='Users') 
ORDER BY ColumnName;