嵌套查詢例子
SELECT C_ID,isnull(FirstSort,'')+'-'+isnull(SecSort,'')+'-'+isnull(Sort,'') SortValue,isnull((select Column_Name from Sort with (nolock) where Column_ID=EnterpriseLibrary.FirstSort),'')+'>>'+isnull((select Column_Name from Sort with (nolock) where Column_ID=EnterpriseLibrary.SecSort),'')+'>>'+isnull((select Column_Name from Sort with (nolock) where Column_ID=EnterpriseLibrary.Sort),'') SortPath FROM EnterpriseLibrary with (nolock) where C_ID=@C_ID
紅色標記的為嵌套查詢例子
posted on 2009-04-08 16:01
sanmao 閱讀(670)
評論(0) 編輯 收藏