create or replace view V_YCJK as SELECT BRZYH,BRXM,ISNULL(ZGQK,2) AS ZGQK,‘PGD‘ LX FROM HL_YCJLJK WHERE ZGQK=‘2‘ UNION ALL SELECT b.BRZYH,b.BRXM,ISNULL(a.BRZGQK,2) AS ZGQK,‘ZGD‘ LX FROM HL_YCZGJK a INNER JOIN HL_YCJLJK b ON a.jkid=b.jkid AND ZGQK=‘2‘
原文：http://my.oschina.net/u/923266/blog/350800