RE: Query debugging

[Colt Brunton]

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?