[thelist] Adding Custom Info to Primary Keys in SQL

[RUST Randal]

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