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