Select statement to join tables?

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

Was this answer helpful?

 Print this Article

Also Read

Does mysql support foreign keys ?

The answer to this is two-fold.Yes. MySQL _DOES_ allow the creation of foreign key constraints...

I'm new to MySQL, where should I start?

Useful Tutorials:Examples on using MySQL commands:...

What are the differences between GROUP BY and ORDER BY...the manual is not clear on this

GROUP BY is a way to sub-total your results, or perform some other "aggregate" function on...

How do I delete a table from a database?

Use this sql command "DROP TABLE yourtablename"

How can i select random rows from a table?

SELECT * FROM table_name ORDER BY RAND();Found at...