'SELECT dbo.T_Study.*, dbo.T_CarManage.* '+
'FROM dbo.T_CarManage INNER JOIN dbo.T_Study ON'+
' dbo.T_CarManage.RecordID = dbo.T_Study.RecordId'+
'WHERE (dbo.T_Study.NianFen = '''+Trim(edtYear.Text)+''') AND (dbo.T_CarManage.G_team like '''+Trim(cbbteam.Text)+'%'')';
帮忙看看这段语句哪出了错?我经过测试是WHERE语句有错,老提示“第一行:=附近有语法错误
'FROM dbo.T_CarManage INNER JOIN dbo.T_Study ON'+
' dbo.T_CarManage.RecordID = dbo.T_Study.RecordId'+
'WHERE (dbo.T_Study.NianFen = '''+Trim(edtYear.Text)+''') AND (dbo.T_CarManage.G_team like '''+Trim(cbbteam.Text)+'%'')';
帮忙看看这段语句哪出了错?我经过测试是WHERE语句有错,老提示“第一行:=附近有语法错误
SELECT dbo.T_Study.*, dbo.T_CarManage.* FROM dbo.T_CarManage INNER JOIN dbo.T_Study ON dbo.T_CarManage.RecordID = dbo.T_Study.RecordIdWHERE (dbo.T_Study.NianFen = 'Edit1') AND (dbo.T_CarManage.G_team like 'Edit2%')注意看where处在where前应该有一空格
'SELECT dbo.T_Study.*, dbo.T_CarManage.* '+
'FROM dbo.T_CarManage INNER JOIN dbo.T_Study ON'+
' dbo.T_CarManage.RecordID = dbo.T_Study.RecordId'+
' WHERE (dbo.T_Study.NianFen = '''+Trim(edtYear.Text)+''') AND //在where前插入空格就搞定了
(dbo.T_CarManage.G_team like '''+Trim(cbbteam.Text)+'%'')';