一个多表查询的问题，大家帮忙解决一下吧

[fengfenghuohuo]

数据库ACCESS
现在有表t1,t2,t3,t4,t5
t1包含站名（key)，编号，地址...
t2包含站名（key),编号，水费...
t3包含站名（key),编号，电费...
t4包含站名（key),房租费...
t5包含站名（key),杂费...
要求根据五张表打印如下信息：编号，站名，地址，水费，电费，房租费，杂费
说明:t1中包含的站名t2,t3,t5中未必包括，但是只要包含的就要打印出来

应该怎么写sql文，谢谢大家指教

[victorycyz]

select 站名,编号，地址，"" as 水费,"" as 电费,"" as 房租费,"" as 杂费 from t1
union
select 站名,编号，"" as 地址，水费,"" as 电费,"" as 房租费,"" as 杂费 from t2
union
select 站名,编号，"" as 地址，"" as 水费,电费,"" as 房租费,"" as 杂费 from t3
union
select 站名,"" as 编号，"" as 地址，"" as 水费,"" as 电费,房租费,"" as 杂费 from t4
union
select 站名,"" as 编号，"" as 地址，"" as 水费,"" as 电费,"" as 房租费,杂费 from t5

[since1990]

支持 victorycyz(中海)