[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


More information about the thelist mailing list