473,320 Members | 2,029 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1454
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Penn Markham | last post by:
Hello all, I am writing a script where I need to use the system() function to call htpasswd. I can do this just fine on the command line...works great (see attached file, test.php). When my...
14
by: bolidev | last post by:
I'm new to SQL and can't figure out how to update my table (StoreItemStatus) that contains the current status for items in each store (STORE_KEY, ITEM_KEY, STATUS,...). I get updated status info...
1
by: moondaddy | last post by:
I'm running vb.net 1.1 and I need to register a dll using regsvcs.exe and am getting the error: Command "RegSvcs.exe" is not valid. the path to the dll I want to register is: D:\nwis\Apps\CSLA...
1
by: Steven Spear | last post by:
Hi. I am trying to perform backtracking with this search function. Something is going wrong when I enter 2 at the command line. Entering 1 at the command line seems to work fine. I notice that...
9
by: Exits Funnel | last post by:
Consider this code which is a very trimmed down version of some I've inherited and am trying to port from windows to g++: //Begin test1.cpp class foo { int i; int j; }; class bar { bar (int...
14
by: Gregory L. Hansen | last post by:
I can't seem to make a queue of objects, using the STL queue. I'm trying to make a little event manager, and I just want someplace to store events. The method definitions for EventManager have...
2
by: bob | last post by:
Could someone help me get the following SQL statement working? SELECT standardgame.gamename, standardgame.rowteamname, standardgame.colteamname, standardgame.dollarvalue, standardgame.gameid,...
6
by: Ted | last post by:
Here is one such function: CREATE FUNCTION my_max_market_date () RETURNS datetime BEGIN DECLARE @mmmd AS datetime; SELECT max(h_market_date) INTO @mmmd FROM holdings_tmp; RETURN @mmmd; END ...
8
by: Bern McCarty | last post by:
I have a simple ref class in its own namespace that needs to coexist with a legacy typedef alias for "unsigned int" in the global namespace that has the identifier as itself. Everything compiles...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.