SQL Performance Question best practive

[Robert Everland III]

Which would be faster

Select users.username,
       project.projectname
From   users inner join project on (users.userid = project.projectowner)

- Or -

Select (select username from users where userid = project.projectowner),
        project.projectname
From   project

Bob

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---