A curiosity about database tables and results simple question

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

A curiosity about database tables and results simple question

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> A curiosity about database tables and results simple question

Page: [1]


nay27uk Posts: 282 Joined: 5/13/2003 From: leicester uk Status: offline	A curiosity about database tables and results simple qu... - 8/27/2003 3:44:18 Ok ive sort of got to terms with geting an asp page to display results from a database table now what i would like to know is this. If you have a database with more than one table and you want to use fields from more than one table in a single asp page how do you go about it. My theary is that you would use strSQL = "Select tablename.fieldname, FROM tablename;" Twice in the asp script so for example strSQL = "Select tablename1.fieldname, FROM tablename1;" strSQL = "Select tablename2.fieldname, FROM tablename2;" Is this how it is done _____________________________ REGARDS NATHAN


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: A curiosity about database tables and results simpl... - 8/27/2003 4:16:40 If the tables have some form of relationship, then you would create a query (in access) to join the information you need. Then, with asp, display the result of the query. If the tables have no relationship, then its simply 2 asp database queries. _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to nay27uk)