insert into alldrivers (a_lname, a_fname) select d_lname, d_fname from drivers where d_currseason != 0 and concat(d_lname,' ',d_fname) not in (select concat(a_lname,' ',a_fname) from alldrivers) order by d_lname, d_fname asc;