string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo) = '" + txtMemberNo.Text + "'";
括号错误了吧。这样你试试。 string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "'");
string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "')";
不知道LZ这条sql语句的目的是什么,如果是查询表LoanedItem中字段LoanNo的值为表Loan中的字段LoanNo的值为 txtMemberNo.Text 的所有记录,可改为: string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "')";
不好意思,应该为:string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "')"; 或: string sqlString = "SELECT a.* FROM LoanedItem a, Loan b WHERE a.LoanNo = b.LoanNo and b.memberNo = '" + txtMemberNo.Text + "'";
string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "'");
string sqlString = "SELECT * FROM LoanedItem WHERE LoanNo in (SELECT LoanNo FROM Loan WHERE memberNo = '" + txtMemberNo.Text + "')";
或:
string sqlString = "SELECT a.* FROM LoanedItem a, Loan b WHERE a.LoanNo = b.LoanNo and b.memberNo = '" + txtMemberNo.Text + "'";