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:

Kas see vastus oli kasulik?

 Prindi artikkel

Loe veel

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...

Do you provide phpMyAdmin web interface to manage the MySQL Database?

Yes, we provide that. You can login to DotNetPanel first Create MySQL Database, create MySQL...

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 them....

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

The best source of MySQL information is the excellent on-line manual : ...