UC知道请高手帮忙解读下面这段“SQL”语句，代表什么意思：
来源：百度知道 编辑：UC知道 时间：2024/06/07 22:02:29
Dim rst,SQL
Set rst = Server.CreateObject("Adodb.Recordset")
SQL1 = "SELECT tbUser.UserID AS UserID, tbUser.PassWord AS Password, tbUser.UserName AS UserName, "
SQL2 = " tbUser.Rights AS uRights, tbDept.DeptName AS DeptName, tbDept.DeptID AS DeptID, tbUser.AdminID "
SQL3 = " "
SQL4 = "FROM tbUser INNER JOIN "
SQL5 = " tbDept ON tbUser.DeptID = tbDept.DeptID "
SQL6 = "WHERE (LTrim(RTrim(tbUser.LoginName)) = '" & LoginName & "') "
SQL = SQL1 + SQL2 + SQL3 + SQL4 + SQL5 + SQL6
'Response.Write SQL&"<BR>"
rst.Open Sql,Conn,adOpenforwardOnly,adLockReadOnly
Set rst = Server.CreateObject("Adodb.Recordset")
SQL1 = "SELECT tbUser.UserID AS UserID, tbUser.PassWord AS Password, tbUser.UserName AS UserName, "
SQL2 = " tbUser.Rights AS uRights, tbDept.DeptName AS DeptName, tbDept.DeptID AS DeptID, tbUser.AdminID "
SQL3 = " "
SQL4 = "FROM tbUser INNER JOIN "
SQL5 = " tbDept ON tbUser.DeptID = tbDept.DeptID "
SQL6 = "WHERE (LTrim(RTrim(tbUser.LoginName)) = '" & LoginName & "') "
SQL = SQL1 + SQL2 + SQL3 + SQL4 + SQL5 + SQL6
'Response.Write SQL&"<BR>"
rst.Open Sql,Conn,adOpenforwardOnly,adLockReadOnly
拼凑一个SQL语句，最后sql的值就是sql1+sql2+sql3+sql4+sql5+sql6
即:select tbuser.userid as userid,tbuser.password as password,tbuser.username as username,tbuser.rights as urights,tbdept.deptname as deptname,tbdept.deptid as deptid,tbuser.asminid from tbuser inner join tbdept on tbuser.deptid=tbdept.deptid where (ltrim(rtrim(tbuser.loginname))='&loginname&')//&loginname&是一个变量，在运行的时候根据实际的值代替它