how to make a query that hits 2 or more tables at same time?

[CavemanUK]

Hi, lets say i have 3 tables set out like this....

tbl_Customers
-------------
id
CustomerName
customertype_id
customerreferrer_id

tbl_CustomerTypes (eg.. Private, Contract etc)
------------------
id
Type

tbl_CustomerReferrers (eg.. Word of Mouth, Advertising etc)
---------------------
id
Referrers


How would i send a query that pulls an array with the following fields..

CustomerName CustomerType CustomerReferrer
Jones Contract Newspaper Advert
Smith Private Word of Mouth

etc

hope this makes sense.

 

[angelwatt]

Here's some reads on using JOIN in queries, which is what you're after.

http://www.tizag.com/mysqlTutorial/mysqljoins.php
http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php
http://phpweby.com/tutorials/mysql/32

 

[sleaver]

As has been said, have a look at JOINS.

Although this could be putting my SQL skills at risk I thought I'd try and post my first helpful post rather than asking questions, the following should do what you want:

SELECT CustomerName, Type AS CustomerType, Referrer AS CustomerReferrer
FROM tbl_Customers
LEFT JOIN tbl_CustomerTypes ON tbl_Customers.customertype_id = tbl_CustomerTypes.id
LEFT JOIN tbl_CustomerReferrers ON tbl_Customers.customerreferrer_id = tbl_CustomerReferrers.id

 

[Laird Knox]

Here's some reads on using JOIN in queries, which is what you're after.

Unless you are working with Google AppEngine - in that case you are just out of luck.