CODEWITHSUNDEEP
sql
user5307053
user5307053

Reputation:

SQL QUERY disturbing Error

I have to write a query which displays the First and Last Name for all users who belong to the Role “Lumo Advantage”.

I wrote it as:

SELECT Users.FirstName, Users.LastName
INNER JOIN Users
ON UserRoles.UserID = Users.UserID
WHERE UserRoles.RoleID =7;

But it is showing error. why? Kindly point out the mistake.

Upvotes: 1

Views: 53

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269543

Perhaps because you left out a from clause:

SELECT Users.FirstName, Users.LastName
FROM Users INNER JOIN
     UserRoles
     ON UserRoles.UserID = Users.UserID
WHERE UserRoles.RoleID = 7;

I would suggest you learn to use table aliases . . . so queries are easier to write and to read:

SELECT u.FirstName, u.LastName
FROM Users u INNER JOIN
     UserRoles ur
     ON ur.UserID = u.UserID
WHERE ur.RoleID = 7;

Upvotes: 1

Related Questions