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
SQL server Joins
March 25th, 2015 8:32pm
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
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2015 8:48pm
"tblDepartment does not exist"
May be
Object is not exist in current database
May be miss to write proper table name .
March 29th, 2015 2:46am