ACCESS - Insert i en liste fra en anden
ACCESSjeg skal indsætte nogle værdier fra 1 liste i en anden, vil følgende SQL virke:
INSERT INTO mmm_master (FirstName, LastName, Company, Address1, City, ZipPostalCode, Country, Phone, EmailAddress1)
FROM element5_orders (FIRSTNAME, LASTNAME, COMPANY, STREET, CITY, ZIP, COUNTRY, PHONE, EMAIL)