请把以下语句缩写一下...selecta.Id,a.Currency,a.Means,a.Program,a.Condition,a.Deal,a.NeedDatum,a.Accessory,a.State,a.Job,a.How,a.Department,a.JobType,(selectClassNamefromw...
请把以下语句缩写一下. ..
select a.Id,a.Currency,a.Means,a.Program,a.Condition,a.Deal,a.NeedDatum,a.Accessory,a.State,a.Job,a.How,a.Department,a.JobType,(select ClassName from wj_class where ClassId=a.Knowledge) as Study,(select ClassName from wj_class where ClassId=a.Knowledge2) as Study2,a.Call,a.SpecialtyNeed,a.Bewrite,a.Confine,a.SchoolAge,a.Age,a.Sex,a.EndTime,a.AddTime,a.User_Id,a.IsCurrency,a.Click, (select [name] from wjvipinfo where user_id=a.user_id) as [name],(select [name] from WjProvince where id=(select Province from WjVipInfo where user_id=a.user_id)) as Province,(select City from WjVipInfo where user_id=a.user_id) as City,(select IsGroom from Wj_Forum_User where Id=a.User_Id) as Groom from wjvipjob as a where a.State=1
分不在高,有心就行~
首先,先感谢大家对该问题的热情回答~
补充说明一下,我需要的是该条语句的缩略写法,对于视图和存储过程 并不是我想要的答案`~ demonpang left 附近语法有错误
展开