Re: sequential joins

Oleg,

> the sub-select statement I was using were not for filtering data (in
>  which
> case you can move filtering condition in ON part of the join), but
>  rather
> renaming the column 'username' with the name I need in the current
>  join
> statement. In this case, columns with new names ('artist',
>  'designer',
> 'programmer') would be appended to the overall query result and can
>  be
> selected by top-level select statement.
> This looks like a very clumsy way to do what I need.
> Any ideas?

No, now I'm confused.  Can you explain better what you are trying to
 achieve as a result?

-Josh