Same way as you would alias any table in your FROM
clause, i.e.:
FROM table AS t1 LEFT OUTER JOIN table AS t2
ON t1.field = t2.field
The AS keyword is optional here, but I think preferred
for clarity.
--- David Link <dlink@soundscan.com> wrote:
> How does one specify an alias for the table being
> joined. This is
> important if you are creating an outer join to the
> same table:
__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com