Selection Across related tables
I am trying to do a find across tables - here would be a simple example of what I would be trying to do.
A database that has two tables - one for individuals and their addresses and phone numbers, and another one with the transactions (date purchased, product). These are connected by a unique ID assigned to the individual and is used when creating the transaction purchase.
I want to find those people who live in Ohio and purchased a sweater. Additionally I want to show what city/town they live in and the date of the purchase.
So the idea is to select on a single field in two two different tables and show a couple of fields from each of the two tables.