INSERT INTO NewTable (Field1,Field2) SELECT FName , LName FROM OldTable WHERE City IN ('Tehran', 'Gilan')