怎么用SQL语句把两张表的不同字段用一个字段显示出来

语句分sql server和mysql sql server语句 select A.a + B.e as f from A inner join B on A.b = B.b mysql 语句 select concat(A.a,B.e) as f from A inner join B on A.b = B.b