SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: How do you join tables?
Threaded View
-
Sep 8, 2001, 04:44 #1
- Join Date
- Jul 2001
- Location
- cheshire
- Posts
- 83
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
How do you join tables?
I would like to know how to write a query that will pull data from two tables. The first table called 'personal details' has a column called 'userid' which is the same column in the 'testscores' table - in this table it is called 'id'
I want the 'firstname' and 'surname' from the 'personaldetails' table and the 'testscore' from the 'testscores' table.
Bookmarks