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

Mo Haidar
  • 3,748
  • 6
  • 37
  • 76

0 Answers0