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