[thelist] Adding Custom Info to Primary Keys in SQL

rudy r937 at interlog.com
Wed Feb 5 09:44:36 CST 2003


> 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







More information about the thelist mailing list