联合两表建视图

来源:互联网 发布:淘宝店铺两心小号 编辑:程序博客网 时间:2024/04/29 18:24
CREATE VIEW viewname        AS  select student_id as id, student_name as name from student union select teacher_id as id ,teacher_name as name from teacher