[qualsiasi linguaggio]Insert in access

[Sypher]

ho risolto così:

InsertPeopleGroup = "INSERT INTO PEOPLEGROUPS (PEOPLE_SYSTEM_ID,GROUPS_SYSTEM_ID) ";
InsertPeopleGroup += " SELECT "+NewSystemID+",SYSTEM_ID FROM GROUPS WHERE GROUP_ID='" + groupsid[i].ToUpper() + "'";