trouble with syntax

[Mikael Hellström]

hi!!
This is my problem. Im planing this without success

*i have 3 tables table1 table2 and table3...
*The tables have some fields with the same name for example
both table 2 and table 3 have the field "age"
*The field id is a key

select * from a table1, b table2, c table3 where a.id=session("memberId")
and b.id= session("memberId") and c.id=session("memberId")

MY QUESTION ARE
How do i get data from tables that have the same field name like the example
table 2 and table 3???
My guess are something like this:

response.write recordsset(b.age) and for the other
response.write recordset(c.age)..

This is wrong syntax i know, but how do i write the syntax in asp?

 

[Bob Barrows]

Mikael Hellström wrote:
Already answered in .asp.db.

Mikael,
The .asp.db newsgroup was the appropriate newsgroup for this question: it
was database-related, and it was asp-related - a great fit for .asp.db. You
did not have to post it here as well. Most of the experts in this group also
subscribe to that group as well, and it can be annoying to have to read the
same question multiple times. In addition, by posting the same question
separately in these newsgroups, you created a "multipost". This is bad
because users in one group cannot see replies to the question from the other
group. This could cause somebody to waste his time answering a question that
has already been answered in the other group, which will certainly be
annoying, and may cause the person who wasted his time to put you on Ignore.
Who knows, this person may be the only person in the newsgroups who knows
the answer to your next question, and you're never going to receive his
answer.

The best policy is, post your question to one appropriate newsgroup. If
you've posted it in the wrong place, someone will let you know, and
hopefully will be polite enough to suggest a more appropriate newsgroup. If
you can't decide which of several newsgroups is the most appropriate, use
the cross-posting technique: put the names of the newsgroups into the To
field of a single message and post it once. It will be posted to all the
groups in your To field. The benefit is that replies to the message will
appear in all the newsgroups to which you cross-posted it, so subscripers to
all the groups will know that your problem has been resolved. The downside
is that extra bandwidth will be used as a result, so always strive to keep
the number of cross-posted groups to a minimum.

HTH,
Bob Barrows

 

[Mikael Hellström]

ok sorry ...I'll think about that.