p2p.wrox.com: Archives - asp_web

asp_web_howto thread: Table Join issues

Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Fri, 12 Jul 2002 17:03:18 +0000

<html><div style='background-color:'><DIV>
<DIV>
<DIV>I'm trying to join three tables together. One table is an PeopleID table which has the attributes of each user. UserName
Password IP etc...... . My other datapools with data entered by the user has just the ID from entered so I can tell which user at
what time entered that data. I already have two datapools joined together but im trying to attach the peopleID database to all the
datapools so that I can identify which user entered what etc..... Can anyone direct me in the right direction of where I can find
documentation on this i will paste the sql statement in the next reply </DIV>
<DIV>thanks</DIV>
<DIV>Jonathan</DIV></DIV></DIV></div><br clear=all><hr>Chat with friends online, try MSN
Messenger: <a href='http://g.msn.com/1HM1ENUS/c144??PS=47575'>Click Here</a><br></html>

Message #2 by "Larry Woods" <larry@l...> on Fri, 12 Jul 2002 10:14:44 -0700

This is a multi-part message in MIME format.

------=_NextPart_000_019A_01C2298C.F18F5D20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

If you have Access, build a query in Access that gives you what you want.
Then, click View/SQL menu and copy the SQL, modify as needed, etc.

Larry Woods

  -----Original Message-----
  From: Jonathan Marshall [mailto:jdmarsh2g@h...]
  Sent: Friday, July 12, 2002 10:03 AM
  To: ASP Web HowTo
  Subject: [asp_web_howto] Table Join issues


  I'm trying to join three tables together. One table is an PeopleID table
which has the attributes of each user. UserName Password IP etc...... . My
other datapools with data entered by the user has just the ID from entered
so I can tell which user at what time entered that data. I already have two
datapools joined together but im trying to attach the peopleID database to
all the datapools so that I can identify which user entered what etc.....
Can anyone direct me in the right direction of where I can find
documentation on this i will paste the sql statement in the next reply
  thanks
  Jonathan


----------------------------------------------------------------------------
--
  Chat with friends online, try MSN Messenger: Click Here
  --- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to

Message #3 by "Jonathan Marshall" <jdmarsh2g@h...> on Fri, 12 Jul 2002 17:58:34 +0000

<html><div style='background-color:'><DIV>
<P>Hey Larry, <BR>I tried that and I get the data results that I want inside of Access but when I paste that code inside
of the ASP script I come back with an error stating the the join is incorrect. I will go bakc and check
again.<BR>thanks</P>
<P><BR>jonathan <BR><BR></P></DIV>
<DIV></DIV>
<DIV></DIV>&gt;From: "Larry Woods" <LARRY@L...>
<DIV></DIV>&gt;Reply-To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>
<DIV></DIV>&gt;To: "ASP Web HowTo" <ASP_WEB_HOWTO@P...>
<DIV></DIV>&gt;Subject: [asp_web_howto] RE: Table Join issues 
<DIV></DIV>&gt;Date: Fri, 12 Jul 2002 10:14:44 -0700 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;If you have Access, build a query in Access that gives you what you want. 
<DIV></DIV>&gt;Then, click View/SQL menu and copy the SQL, modify as needed, etc. 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Larry Woods 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; -----Original Message----- 
<DIV></DIV>&gt; From: Jonathan Marshall [mailto:jdmarsh2g@h...] 
<DIV></DIV>&gt; Sent: Friday, July 12, 2002 10:03 AM 
<DIV></DIV>&gt; To: ASP Web HowTo 
<DIV></DIV>&gt; Subject: [asp_web_howto] Table Join issues 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; I'm trying to join three tables together. One table is an PeopleID table 
<DIV></DIV>&gt;which has the attributes of each user. UserName Password IP etc...... . My 
<DIV></DIV>&gt;other datapools with data entered by the user has just the ID from entered 
<DIV></DIV>&gt;so I can tell which user at what time entered that data. I already have two 
<DIV></DIV>&gt;datapools joined together but im trying to attach the peopleID database to 
<DIV></DIV>&gt;all the datapools so that I can identify which user entered what etc..... 
<DIV></DIV>&gt;Can anyone direct me in the right direction of where I can find 
<DIV></DIV>&gt;documentation on this i will paste the sql statement in the next reply 
<DIV></DIV>&gt; thanks 
<DIV></DIV>&gt; Jonathan 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;---------------------------------------------------------------------------- 
<DIV></DIV>&gt;-- 
<DIV></DIV>&gt; Chat with friends online, try MSN Messenger: Click Here 
<DIV></DIV>&gt; --- Improve your web design skills with these new books from Glasshaus. 
<DIV></DIV>&gt;Usable Web Menus 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 Constructing Accessible Web Sites 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 Practical JavaScript for the Usable Web 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to 
<DIV></DIV>&gt;unsubscribe send a blank email to  
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;--- 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Improve your web design skills with these new books from Glasshaus. 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;Usable Web Menus 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 
<DIV></DIV>&gt;Constructing Accessible Web Sites 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 
<DIV></DIV>&gt;Practical JavaScript for the Usable Web 
<DIV></DIV>&gt;http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme 
<DIV></DIV>&gt;r-20 
<DIV></DIV>&gt; 
<DIV></DIV>&gt; 
<DIV></DIV>&gt;--- 
<DIV></DIV>&gt;
<DIV></DIV>&gt;
<DIV></DIV></div><br clear=all><hr>Chat with friends online, try MSN Messenger: <a
href='http://g.msn.com/1HM1ENUS/c144??PS=47575'>Click Here</a><br></html>

Return to Index

P2P Archives