sqlserver:
select 发文单位+文号 as 发文单位文号 from table;
oracle:
select 发文单位||文号 as 发文单位文号 from table;
select concat(发文单位,文号) as 发文单位文号 from table;
mysql:
select concat(发文单位,文号) as 发文单位文号 from table;
access的语法和sqlserver的一样,就不赘述了
http://www.360doc.com/content/15/1030/16/19584156_509473580.shtml