数据库ACCESS
现在有表t1,t2,t3,t4,t5
t1包含站名(key),编号,地址...
t2包含站名(key),编号,水费...
t3包含站名(key),编号,电费...
t4包含站名(key),房租费...
t5包含站名(key),杂费...
要求根据五张表打印如下信息:编号,站名,地址,水费,电费,房租费,杂费
说明:t1中包含的站名t2,t3,t5中未必包括,但是只要包含的就要打印出来应该怎么写sql文,谢谢大家指教
现在有表t1,t2,t3,t4,t5
t1包含站名(key),编号,地址...
t2包含站名(key),编号,水费...
t3包含站名(key),编号,电费...
t4包含站名(key),房租费...
t5包含站名(key),杂费...
要求根据五张表打印如下信息:编号,站名,地址,水费,电费,房租费,杂费
说明:t1中包含的站名t2,t3,t5中未必包括,但是只要包含的就要打印出来应该怎么写sql文,谢谢大家指教
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