Entry

Select statement to join tables?

Feb 13th, 2003 17:11
Carpe DM, Tim Mousel,

For a simple join:
SELECT a.*, b.*
FROM tblAlpha a, tblBeta b
WHERE (a.keyfield = b.foreignkey);
It's often smarter to do an outer join, especially if you need rows in 
tblAlpha to show up in your resultset even if there is no matching 
record in tblBeta:
SELECT a.*, b.*
FROM tblAlpha a LEFT OUTER JOIN tblBeta b
 ON a.keyfield = b.foreignkey;
If you want to get into the nuts and bolts of it, the MySQL doc is 
found at:
http://www.mysql.com/doc/en/JOIN.html
and ZDNet has a decent article at:
http://www.zdnet.com.au/builder/architect/database/story/0,2000034918,20
267371,00.htm