sql 左外连语句解析

string SQLString = @"declare @str varchar(1000) //声明变量@str，并定义类型
select top 1 @str= courseTypelist  from dbo.sys_grade where gid = '{0}' //按照gid = '{0}'（相当于ddl_grade.SelectedValue）从dbo.sys_grade取courseTypelist列的第一条记录并赋值给变量@str


select istr , tname,eid, score,you,liang,jige,
year, case team when '0' then '上学期' when '1' then '下学期' end as team ,cname
 from(
select istr , tname  from fsplit(@str ,',') as t
left join dbo.sys_courseType as c on c.cid = t.istr ) as z//查询出的courseTypelist是个课程类型集合，将按照年级查询出来的courseTypelist分割成这几个courseType组成的表，其中istr是课程id，tname是课程名字


left join (select * from sys_exam where year='{1}' and team='{2}' and gid = '{0}') as s on s.coursetypeid = z.istr//按照下拉选项ddl_grade.SelectedValue（gid = '{0}'）, ddl_year.SelectedValue（year='{1}' ）, ddl_team.SelectedValue（team='{2}'）查询出sys_exam中所有（ s.coursetypeid = z.istr）id一致的课程
left join dbo.sys_grade as g on g.gid = s.gid

group by istr,eid ,tname,score,you,liang,jige,year,team,cname";

 SQLString = string.Format(SQLString, ddl_grade.SelectedValue, ddl_year.SelectedValue, ddl_team.SelectedValue);