[thelist] Adding Custom Info to Primary Keys in SQL

[rudy]

> 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