justrite

Can you show me what that would look like? I am new to SQL and have not coded with it except to show records and compile data. Thanks Mike

I have 4 tables that have bus tour data for each season cms_fall_tourscms_spring_tourscms_summer_tourscms_winter_tours I also have an empty table that has the same columns cms_all_tours I want to take each of the season tours and combine them into the ALL Tours table OR take the season tables and create a new table "cms_all_tours" with them (after deleting the current cms_all_tours of course) Any help with the query string on this would be appreciated MichaelJust Rite Design