ISNULL用法:
多表查询统计结果时,部分字段内容为空,可以自动补充默认值
select ISNULL(S.[state], 0),ISNULL(S.[insertUserId], 4869) from [train_video_data] V
LEFT JOIN [train_video_study_data] S ON V.[courseId] = S.[courseId] AND V.[videoId] = S.[videoId]
where V.[courseId] = 636235546473141211 AND V.[state] = 1