请教一个JOIN语法的问题
在下面语句:
Dim sql As String
sql = "select 选课_子表.*,课程.科目名称,课程.学分"
sql = sql & " from (选课_子表 left join 选课_父表 on 选课_子表.登录序号=选课父表.登录序号) left join 课程 on 课程.科目编号=选课_子表.科目编号"
sql = sql & " where 选课_子表.登录序号=" & "'" & rs1![登录序号] & "'"
sql = sql & " order by 选课_子表.科目编号"
Set rs2 = db.OpenRecordset(sql, dbOpenDynaset)
运行时报"join语法错误",哪位大侠帮帮我