Código:
SELECT a.campo1, a.campo2, b.campo1 as alias FROM tabla1 a INNER JOIN tabla2 b ON a.campoID = b.campoID WHERE condicion
asi
Do While Not rs.Eof
Response.Write rs("alias")
Loop
o asi
Don While Not rs.Eof
Response.Write rs("aliascampo1")
Loop
o como?????