> 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