创建视图,多表联

来源:互联网 发布:软件购买合同范本 编辑:程序博客网 时间:2024/04/30 01:46
创建视图,多表联合:
select `comment`.`phone` AS `phone`,`comment`.`rtime` AS `rtime` from `vcomment` union select `vshare`.`send_phone` AS `phone`,`share`.`rtime` AS `rtime` from `share` union select `support`.`phone` AS `phone`,`support`.`rtime` AS `rtime` from `support`
0 0
原创粉丝点击