[thelist] select kt.rank in ASP
Joel D Canfield
joel at bizba6.com
Mon Mar 17 13:29:17 CDT 2008
> I recently inherited an ASP (classic) site, and one of the
> search pages has code that includes "select kt.rank,
> e.SubTopic..." etc. I'm new to this concept, and I'm
> wondering if "e" is a temporary table, and if so, how/where
> it might be set up? I'm troubleshooting this page, and this
> is the current hold up.
> Thanks for any help you might be able to provide.
> Kind Regards,
> Louis
howdy, Louis. both 'kt' and 'e' are probably aliases, nicknames for
existing tables. somewhere in that query there's a 'from' clause where
it says something like
from mytable kt, yourtable e where blah blah blah
if that ain't crystal clear, just shout
joel
More information about the thelist
mailing list