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


 
 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'

 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