42 lines
707 B
Transact-SQL
42 lines
707 B
Transact-SQL
|
|
|
|
|
|
|
|
ALTER VIEW [dbo].[View_Training_TestTrainingItem] AS
|
|
/*ÅàѵÊÔÌâÐÅÏ¢ÊÓͼ*/
|
|
SELECT Training.TrainingId
|
|
,Training.TrainingCode
|
|
,Training.TrainingName
|
|
,Item.TrainingItemId
|
|
,Item.TrainingItemCode
|
|
,Item.TrainingItemName
|
|
,Item.Abstracts
|
|
,Item.AbstractsEng
|
|
,Item.AttachUrl
|
|
,Item.VersionNum
|
|
,Item.TestType
|
|
,Item.WorkPostIds
|
|
,Item.WorkPostNames
|
|
,Item.AItem
|
|
,Item.BItem
|
|
,Item.CItem
|
|
,Item.DItem
|
|
,Item.EItem
|
|
,Item.AItemEng
|
|
,Item.BItemEng
|
|
,Item.CItemEng
|
|
,Item.DItemEng
|
|
,Item.EItemEng
|
|
--,Item.Score
|
|
,Item.AnswerItems
|
|
,Item.DepartIds
|
|
,Item.DepartNames
|
|
FROM dbo.Training_TestTrainingItem AS Item
|
|
LEFT JOIN Training_TestTraining AS Training ON Item.TrainingId = Training.TrainingId
|
|
|
|
|
|
|
|
|
|
|
|
|