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


  
New Topic  |  Go to Top  |  Go to Topic  |  Threaded View  |  Search 
 Newer Topic  |  Older Topic
 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

Reply To This Message
 Re: Joining Fields - Multiple Table SELECTS ????
Author:  (---.scpe.powergate.ca)
Date:   02-24-04 12:33

select a.fname, a.lname, b.class_name from
table1 a, table2 b
where
a.autoInc_id = b.table1_id

Reply To This Message
 Re: Joining Fields - Multiple Table SELECTS ????
Author:  (---.ewetel.net)
Date:   02-27-04 04:22

Try this:

SELECT t2.Class_NAME, t1.* FROM Table2 AS t2
LEFT JOIN Table1 AS t2
ON t2.AutoInc_ID=t1.AutoInc_ID
WHERE t2.Class_Name='a_class_name'

Reply To This Message
Go to Top  |  Go to Topic  |  Threaded 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