--测试数据createtabletb_kq(banzuvarchar(20),chuqinqkvarchar(20),namevarchar(20),primarykey(banzu,chuqinqk,name));insertintotb_kq(banzu,chuqinqk,name)select'班组1','出勤','张1'unionselect'班组1','出勤','张2'unionselect'班组1','出勤','张3'