ÇÉÓÃSQLÖеÄWITH£¨Ê÷ÐͽṹÊý¾ÝµÄ²éѯ£©
Èç¹û±íÖдæ·ÅµÄÊý¾ÝÊÇÊ÷Ðνṹ£¬µ±ÖªµÀijһ¸ö½ÚµãµÄֵʱ£¬Í¬Ê±ÏëÈ¡µÃËüËùÓÐ×Ó½ÚµãµÄÊý¾Ý¡£
±í½á¹¹£º
±íÖдæ·ÅµÄÊDz¿ÃÅ×éÖ¯½á¹¹£¬ BMN_CD²¿ÃÅ£¬SSK_KAISO_LVÊǽײ㣬BMN_MKJ²¿ÃÅÃû³Æ£¬JOI_KAISO_LVÉÏλ½×²ã£¬JOI_BMN_CDÉÏλ²¿ÃÅ¡£
¼ìË÷SQL :
WITH Moduals (BMN_CD, SSK_KAISO_LV, BMN_MKJ, BMN_NM_RYKS, SKI_FLG, JOI_KAISO_LV, JOI_BMN_CD) AS (SELECT
T130A.BMN_CD,
T130A.SSK_KAISO_LV,
T130A.BMN_MKJ,
TRIM(T130A.BMN_NM_RYKS) BMN_NM_RYKS,
T130A.SKI_FLG,
T130A.JOI_KAISO_LV,
T130A.JOI_BMN_CD
from
T130 T130A
WHERE
T130A.BMN_CD = 'B00011' AND
UNION ALL
SELECT
T130B.BMN_CD,
T130B.SSK_KAISO_LV,
T130B.BMN_MKJ,
TRIM(T130B.BMN_NM_RYKS) BMN_NM_RYKS,
T130B.SKI_FLG,
T130B.JOI_KAISO_LV,
T130B.JOI_BMN_CD
from
T130 T130B
INNER JOIN Moduals T130C
ON T130B.JOI_KAISO_LV = T130C.SSK_KAISO_LV
AND T130B.JOI_BMN_CD = T130C.BMN_CD
)
SELECT Moduals.BMN_CD,SSK_KAISO_LV, BMN_MKJ, BMN_NM_RYKS, SKI_FLG, JOI_KAISO_LV, JOI_BMN_CD from Moduals
¡¾ WHERE ………… ¡¿
Èç¹û¶Ô¼ìË÷½á¹û»¹ÓÐÏÞÖƵĻ°£¬¿ÉÒÔ¼ÓWHEREÓï¾ä½øÐÐÏÞÖÆ¡£¡£¡£¡£¡£¡£¡£¡£
¼ìË÷½á¹û£º
Ïà¹ØÎĵµ£º
Çë½Ì¸ßÊÖÒ»¸öÎÊÌ⣬ÎÊÌâÃèÊöÈçÏ£º
A±íÊǸ÷¸öµ¥Î»µÄÃû³Æ±í ×Ö¶ÎΪ org_id ºÍ org_name
B±íÊÇÕâЩµ¥Î»µÄµç»°ºÅÂë±í ×Ö¶ÎΪ org_idºÍ tel
A±í B±í¹ØÁª·½Ê½ÎªA.ORG_ID=B.ORG_ID
org_idÊǸ÷¸öµ¥Î»µÄ´úÂë
org_nameÊǸ÷¸öµ¥Î»µÄÃû³Æ
telÊǸ÷¸öµ¥Î»µÄµç»°ºÅÂë
±¾ÈËÏÖÔÚÏëÕë¶Ôÿ¸öµ¥Î»£¨Ã¿Ìõorg_id£©È¡Æä10¸öºÅÂë
Ç ......
SELECTÓï¾äµÄÍêÕûÓ﷨Ϊ£º
SELECT[ALL|DISTINCT|DISTINCTROW|TOP]
{*|talbe.*|[table.]field1[AS alias1][,[table.]field2[AS alias2][,…]]}
from tableexpression[,…][IN externaldatabase]
[WHERE…]
[GROUP BY…]
[HAVING…]
[ORDER BY…]
[WITH OWNERACCESS OPTION]
×¢ ......
×÷Õß:Íø·ÓÎÏÀ@youxia.org
·¢²¼Ê±¼ä:2005-9-25 11:48:18 ÎÄÕÂÀ´Ô´:youxia.org
̨ʽ»úºÍ±¾±¾·Ö±ð°²×°ÁËMS SQL Server£¬·½±ã×ö²âÊÔÓÃ
½á¹ûʱ¼ä³¤ÁË£¬
̨ʽ»úSQL ServerµÄÃÜÂëÍü¼ÇÁË……
ÄѵÀ……ûÓа취ÁËÂ𣿗—No£¡
¾¹ýÒ»Õó×ÓÓôÃÆ£¬ÓÎÏÀÔÚ°Ù¶ÈËѵ½ÁË·½·¨£º
ÏÖÔÚÄãµÄ
ÆóÒ ......