Sorry Rudy
Still no luck.... Can't seem to figure out what's wrong.....
CREATE TABLE Contact
SELECT
ContactNo,
Work_Address,
Field20,
Work_City,
Work_State,
Work_Zip,
Work_Country
FROM import
UNION ALL
SELECT
ContactNo,
Home_Address,
Field26,
Home_City,
Home_State,
Home_Zip,
Home_Country
FROM import
WHERE Home_Address IS NOT NULL;
CREATE TABLE ADDRESS
SELECT
Work_Address,
Field20,
Work_City,
Work_State,
Work_Zip,
Work_Country
FROM import
UNION ALL
SELECT
Home_Address,
Field26,
Home_City,
Home_State,
Home_Zip,
Home_Country
FROM import
WHERE Home_Address IS NOT NULL;
Is there any way of getting more information from MySQL?