What is wrong with this sql syntax?
Hai guys,
I got the error Cannot call methods on nva开发者_开发技巧rchar.
when i executed the below sql query
select User.[User_Id],User.[User_Name],User.Email_Id,User.Password,Role.Role_Id,Role.Role_Name,Role.Role_Description
From [User] inner join [Role] on User.Role_Id=Role.Role_Id
what is wrong in the above query?
You may need to delimit user
as [user]
. I believe it is a reserved keyword.
精彩评论