If tables are constantly being joined and information needs to be quickly retrieved, Views can be used to retrieve data quickly.

Code Downloads
v_people_list_short.sql.zip
People_List.sql.zip
SampleDb.sql.zip