第一题: select t.col_1,t.col_2,t.col_3,col_11,t.col_4 from (select t2.col_1,t2.col_2,t1.col_3,t1.col_1 as col_11,t1.col_4 from ( select * from Table_B )t1 left join( select * from Table_A )t2 on t1.col_1=t2.col_1 union all select * ,'NULL','NULL','NULL' from Table_A where col_1='c' )t order by t.col...