Creating JOIN on three tables
All-
I am writing a simple query where I am trying to get data from three different tables. Below are the three tables. How do I create an inner join between these three tables? Do I join Person, Address tables and Address, Transactions tables OR Do I join Person, Address tables and Person, Transactions tables?
PERSON (Table Name)
OID_PERSON
________________________________________
PREFIX
FIRSTNAME
LASTNAME
SUFFIX
GENDER
ADDRESS (Table Name)
OID_ADDRESS
________________________________________
OID_PERSON (FK)
ADDRESS1
ADDRESS2
CITY
STATE
ZIP
PLUS4
TRANSACTIONS (Table Name)
OID_TRANSACTION
________________________________________
OID_PERSON (FK)
TRANSACTION_DATE
TRANSACTION_AMOUNT
TRANSACTION_TYPE