sql查询:
多表联合查询:将具有相同的字段的查询结果合并为一个表
关键字:union
实例:
查询subs表
select subs_id,prefix,acc_nbr,cust_id,user_id,acct_id,price_plan_id,area_id,update_date
from subs
where acc_nbr=939106638 --acc_nbr
结果:
1 432 95939106638 197197 248124 1202012/1/10 12:07:43 2 439 95939106638 200200 250124 1202012/1/10 13:16:50 3 425 95 939106638 199 199 247 124 120 2012/1/10 10:15:24 4 409 95939106638 199199 247124 1202012/1/9 13:46:43
查询subs_his表:
select subs_id,prefix,acc_nbr,cust_id,user_id,acct_id,price_plan_id,area_id,update_date
from subs_his
where acc_nbr=939106638 --acc_nbr
结果:
1 414 95939106638 199199 247124 1202012/1/9 14:28:20 2 414 95939106638 199199 247124 1202012/1/9 14:00:38
联合查询结果:
语句:
select subs_id,prefix,acc_nbr,cust_id,user_id,acct_id,price_plan_id,area_id,update_date
from subs
where acc_nbr=939106638 --acc_nbr
union select subs_id,prefix,acc_nbr,cust_id,user_id,acct_id,price_plan_id,area_id,update_date
from subs_his
where acc_nbr=939106638 --acc_nbr
查询结果:
1 409 95939106638 199199 247124 1202012/1/9 13:46:43 2 414 95939106638 199199 247124 1202012/1/9 14:00:38 3 414 95939106638 199199 247124 1202012/1/9 14:28:20 4 425 95939106638 199199 247124 1202012/1/10 10:15:24 5 432 95939106638 197197 248124 1202012/1/10 12:07:43 6 439 95939106638 200200 250124 1202012/1/10 13:16:50。。