方法:外联接查询
举例:
select A.*,COUNT(B.RegId) from dbo.PR_TrainingClass A left outer join dbo.PR_PracEducationReg B ON A.ClassId=b.ClassId group by A.[Address],A.AreaCode
方法:外联接查询
举例:
select A.*,COUNT(B.RegId) from dbo.PR_TrainingClass A left outer join dbo.PR_PracEducationReg B ON A.ClassId=b.ClassId group by A.[Address],A.AreaCode