Search Help Board

PHP FAQ
PHP Articles
PHP Help
Bulletin Board

PHP Manual (NEW!)
First Time PHP'ers
Help with programming
Sql assignment help
PHP Homework Help


 
 Joining Fields - Multiple Table SELECTS ????
Author:  (---.wireless.umn.edu)
Date:   02-24-04 10:09


Table2 will have multiple records corresponding to a single record in Table1. I want to search in Class_NAME and pull out the corresponding records in Table1.

Table1.AutoInc_ID = Table2.Table1_ID

Table1
AutoInc_ID
Fname
Lname

Table2
AutoInc_ID
Table1_ID
Class_NAME

What kind of select statement will get this done? Thanks for any help that can be provided... Brock

 Topics Author  Date
 Joining Fields - Multiple Table SELECTS ????  new
Brock Noland 02-24-04 10:09 
 Re: Joining Fields - Multiple Table SELECTS ????  new
bastien 02-24-04 12:33 
 Re: Joining Fields - Multiple Table SELECTS ????  new
NoName 02-27-04 04:22 
Go to Top  |  Go to Topic  |  Flat View  |  Search 
  |  
New Topic
 Reply To This Message
 Your Name:
 Your Email:
 Subject:
Email replies to this thread, to the address above.
    

Provided By
Phorum