摘要:拿欄位資料直接查詢別張表並轉出對應
SELECT TimesId ,ParliamentName ,ParliamentSequence ,
ParliamentType =
(
select CodeValue
from SystemCode
where Code = ParliamentType and CodeIndex= 'PType'
)
,StartDate ,EndDate ,UseStatus, AssignDate ,CreatedUserId ,CreatedUserName ,CreatedDate
,ModifiedUserId ,ModifiedUserName ,ModifiedDate
FROM COMTimes
這樣查詢 ParliamentType 會被取代成子查詢結果。