I am getting a syntax error every time I try to run these codes: select  Name, Gender, Salary, DepartmentName  from tblEmployee JOIN tblDepartment  ON tblEmployee.DepartmentId = tblDepartment.Id   I will be happy if anyone can help me figure out why I am getting syntax error which says tblDepartment does not exist.  The departmentName is not in the tblEmployee but in the tblDepartment.    Thanks

 

tblDeaprtment does not exists -  means you may need to check the existence of the table in the database. Are you sure you selected the correct database? Are you able to see the result when querying simple select like "Select* From tblDepartm

"tblDepartment does not exist"

May be

Object is not exist in current database

May be miss to write proper table name .