[thelist] Adding Custom Info to Primary Keys in SQL
RUST Randal
RRust at COVANSYS.com
Wed Feb 5 09:50:03 CST 2003
Rudy said:
> > Now, the next question is, can I apply a name to a joined table?
>
> sure
>
> select foo.onecolumn, bar.othercolumn
> from tablewithuglyname foo
> inner join anotheruglytable bar
> on foo.pk = bar.fk
>
> you can also assign a name to this entire select statement by
> declaring it as a view
Thanks, Rudy!
----------
Randal Rust
Covansys Corp.
Columbus, OH
More information about the thelist
mailing list