Tuesday, January 5, 2010

MySQL Query Browser Using JOIN

This post is labeled under Software Development

This is the continuation of Laboratory Activity 3. I suggest that you do the said lab activity first (if you haven't done so) before proceeding on this activity. You may visit it here.

One of the interesting aspects of SQL is the connection of relational tables. The following activity below explains how to issue a SELECT statement that joins multiple tables.

It starts with the connection of two tables. As you understand the concepts of connecting tables, it will take you to the next step of connecting multiple tables using JOIN, LEFT JOIN, RIGHT JOIN or simply using a WHERE clause.

This activity expands further our knowledge of MySQL Commands and Basic Queries. As with our previous MySQL tutorials, this promises an easy-to-follow format. An exercise is included to check understanding of the concepts.

MySQL Query Browser Activity 4

No comments:

Post a Comment