CREATE OR REPLACE VIEW V_K12_OUTSTORE
AS
SELECT a.*, b.full_name pjtgroupname, c.full_name pjtname,
d.dic_name getpersonname, e.dic_name planpersonname
FROM t_k12_outstore a
LEFT JOIN t_k07_projectgroup b ON a.getunit = b.pjt_group_id
LEFT JOIN t_k07_project c ON b.pjt_id = c.pjt_id
LEFT JOIN t_dictionary d ON a.getperson = d.dic_code
LEFT JOIN t_dictionary e ON a.planperson = d.dic_code
AS
SELECT a.*, b.full_name pjtgroupname, c.full_name pjtname,
d.dic_name getpersonname, e.dic_name planpersonname
FROM t_k12_outstore a
LEFT JOIN t_k07_projectgroup b ON a.getunit = b.pjt_group_id
LEFT JOIN t_k07_project c ON b.pjt_id = c.pjt_id
LEFT JOIN t_dictionary d ON a.getperson = d.dic_code
LEFT JOIN t_dictionary e ON a.planperson = d.dic_code
语法检查成功.但就是不能使用.后来索性不管它.第二天又能用了.一点都没改.
谢谢大家!
(注:我用的是Toad for Oracle Version 8.5.3)