Something like this
select join_alias.col11, join_alias.col21 from
(table1 a INNER JOIN table2 b ON a.col11=b.col21) join_alias
Hope it makes sense.
Please let me know.
Don't think it exists in a format similar to the one you specified above, but you could potentially use a VIEW that does the join, which then you could alias in your main query.
So something like:
select join_alias.col11, join_alias.col21
from vw_Tbl1JoinTbl2OnCol1 as join_alias
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding