two tables with same column names

I have a select statement -

SELECT tblone.FirstName, tblone.LastName, tbltwo.FirstName, tbltwo.LastName,
tblthree.Meet FROM tblone, tbltwo, tblthree WHERE tblthree.VID = tbltwo.ID
AND tblone.CID = tblthree.CID

tblone and tbltwo both have FirstName and LastName columns

Normally I would just write <%=rs.fields("FirstName")%> but then it only
gives me the tblone FirstName. I tried <%=rs.fields("tbltwo.FirstName")%>
but that just errors.

How do I call both tables First and Last Names?

--
Olivia Towery

Brian
Tue May 24 18:58:55 CDT 2005

Olivia,

> SELECT tblone.FirstName, tblone.LastName, tbltwo.FirstName, tbltwo.LastName,
> tblthree.Meet FROM tblone, tbltwo, tblthree WHERE tblthree.VID = tbltwo.ID
> AND tblone.CID = tblthree.CID

use something like this:

SELECT tblone.FirstName AS t1FN, tblone.LastName AS t1LN, tbltwo.FirstName AS
t2FN, tbltwo.LastName AS t2LN,....

then use this: <%=rs.fields("t1FN")%>

Brian