0

I have the following query

select roles.roleId from roles where roles.roleId in (select userRoles.roleId from userRoles where userRoles.userId=10)

which could be done also like this

 select roles.roleId from roles, userRoles where roles.roleId = userRoles.roleId and userRoles.userId = 10;

so which one is better for performance to use the inner join or to use in keyword

Mohamad Haidar
  • 3,210
  • 6
  • 30
  • 71

0 Answers0