摘要： CREATE OR REPLACE VIEW assign_view ASSELECT a.event_batch_id AS event_batch_id, (SELECT concat(u.firstname,' ',u.lastname) FROM user u WHERE u.id = a. 阅读全文