CREATE VIEW dbo.Per_tree AS SELECT dbo.Base_User.User_no, dbo.Base_User.User_wkno, dbo.Base_User.User_name, dbo.Menu_Tree.no, dbo.Menu_Tree.id, dbo.Menu_Tree.node, dbo.Menu_Tree.root, dbo.Menu_Tree.text, dbo.Menu_Tree.open_href, dbo.Menu_Tree.leaf, dbo.Menu_Tree.per, dbo.Menu_Tree.other, dbo.Menu_Tree.orderby FROM dbo.Base_User INNER JOIN dbo.Per_user ON dbo.Base_User.User_per = dbo.Per_user.per_no INNER JOIN dbo.Menu_Tree ON dbo.Per_user.tree_no = dbo.Menu_Tree.id
