1*c3437056SNickeaucreate view IF NOT EXISTS PAGE_REFERENCES_VW as 2*c3437056SNickeauselect 3*c3437056SNickeau p.path as referent_path, 4*c3437056SNickeau pr.reference as reference_path 5*c3437056SNickeaufrom 6*c3437056SNickeau page_references pr 7*c3437056SNickeau inner join pages p on pr.page_id = p.page_id; 8