Subject join stored procedure and select
Author intranetsbi
Hello!
I created stored procedure that returns 0/1 depending if a user has a
role or not. HasRole(UserID,Rolename):returns 0/1

Now I'd like to run a select from all users which have a certain role.
Why "select * from users, HasRole(users.id,'Admin')" is not working?

Thank you!