In this, fifth part of this tutorial I will show you how to join sequences and apply effects to the video clips in Adobe Premiere Pro CS3.

When studying relationships, we reviewed techniques of making data from one table available to the records of another table.

Setting up multiple tables in a database is an easy way to keep related data together.

This lesson will teach you how to do a specialized join: left join.

Thus far we have only been getting data from one table at a time. This is fine for simple takes, but in most real world MySQL usage you will often need to get data from multiple tables in a single query.

A foreign key constraint is not required merely to join two tables.