Insert Into Students(ID,Name,Surname,Class,ClassType,ClassID)(Select ID,Name,Surname,3,A,A1) from StudentsType where ClassType=A group by Id,Name)
var subquery=from a in StudentsType where ..... etc.
var insertquery= ..... // I dont insert StudentsType to Students table.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)