470,613 Members | 2,205 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

trouble with syntax

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?
Jul 19 '05 #1
2 1364
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

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #2
ok sorry ...I'll think about that.

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:ek**************@TK2MSFTNGP10.phx.gbl...
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

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Penn Markham | last post: by
14 posts views Thread by bolidev | last post: by
1 post views Thread by moondaddy | last post: by
1 post views Thread by Steven Spear | last post: by
9 posts views Thread by Exits Funnel | last post: by
14 posts views Thread by Gregory L. Hansen | last post: by
2 posts views Thread by bob | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.