>
> 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
Joins are faster than sub-queries
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
