多表查询错误!!!
我在多表查询的时候sql语句错误,错误提示:Microsoft JET Database Engine (0x80040E14)语法错误 (操作符丢失) 在查询表达式 'member.u_number= and chf.u_number=jl.u_number=chidao.u_number=jiaban.u_number=member.u_number' 中。
<!--#include file="conn.asp"-->
<%
dim u_number
u_number=trim(request("u_number"))
set rs=server.createobject("adodb.recordset")
sql="select * from member, chf, jl, chidao, jiaban where member.u_number="&u_number&" and chf.u_number=jl.u_number=chidao.u_number=jiaban.u_number=member.u_number"
rs.open sql,conn,1,1
%>
<html>
<head>
<title>员工工资</title>
</head>
<body>
<img src="image/title.jpg">
<form action="mod_user2.asp" method="post" name="form1">
<table width="67%" border="1" align="center">
<tr>
<td colspan="2" height="30" bgcolor="#FFFFCC" align="center"><font size="+2">员工工资</font></td>
</tr>
<tr>
<td align="center" width="40%" height="20">员工编号</td>
<td align="center"><input name="u_number" type="text" value="<%=rs("u_number")%>" readonly> </td>
</tr>
<tr>
<td align="center" width="40%" height="20">员工姓名</td>
<td align="center"><input name="u_name" type="text" value="<%=rs("u_name")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">所在部门</td>
<td align="center"><input name="d_number" type="text" value="<%=rs("d_number")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">基本工资</td>
<td align="center"><input name="pay" type="text" ></td>
</tr>
<tr>
<td align="center" width="40%" height="20">奖励</td>
<td align="center">
<input name="prize" type="text" value="<%=rs("prize")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">考勤扣除</td>
<td align="center"><input name="kqkc" type="text" value="<%=rs("kqkc")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">加班奖励</td>
<td align="center"><input name="jb" type="text" value="<%=rs("jb")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">罚款</td>
<td align="center"><input name="fk" type="text" value="<%=rs("fk")%>"></td>
</tr>
<tr>
<td align="center" width="40%" height="20">月份</td>
<td align="center"><input name="month" type="text" ></td>
</tr>
<tr>
<td align="center" colspan="2"><input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重填"></td>
</tr>
</table>
</form>
</body>
</html>