> Why "select * from users, HasRole(users.id,'Admin')" is not working?

select *
from USERS
left outer join HasRole(USERS.id, 'Admin') on 1 = 1;


eMeL


Example:
http://www.emel.hu/ibfb/sp_join_test_sql.txt