访问数据库单表连接 [英] access database single table join

问题描述

您好

Hello

string sql = "";
OleDbConnection conn = new OleDbConnection(oldbconnstring);
sql = "select AttendanceLogs.InTime,AttendanceLogs.OutTime,Employees.EmployeeCode
 FROM AttendanceLogs INNER JOIN Employees ON AttendanceLogs.EmployeeId  =  Employee.EmployeeId";

OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
adapter.Fill(results);

plz帮助我收到错误

语法错误在JOIN操作中。

如何使用C＃

plz help i am getting error
Syntax error in JOIN operation.
how to do single join in access database using C#

推荐答案

在访问数据库中单独加入你在Employee中错过了s。请使用此sql

You have missed s in Employee. Use this sql instead

select AL.InTime,AL.OutTime,E.EmployeeCode
 FROM AttendanceLogs AL INNER JOIN Employees E ON AL.EmployeeId  =  E.EmployeeId

您的表格是在Employ子句中称为Employees ...你有Employee.EmployeeId ......我说这是一个错误：）

Your table is called Employees...in the ON clause you have Employee.EmployeeId...I'd say that is an error :)

这篇关于访问数据库单表连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！