I have a problem with an SQL query. I have a huge book on SQL, but I don't know what I'm attempting to do is called, therefore I don't know what to look up. I will explain it as simply as possible.

Two Tables.

Table1 would look like this:
Code:
PK   PersonnelID
     FirstName
     LastName
FK   MailingAddressID
FK   PhysicalAddressID

Table2 would look like this:


Code:
PK    AddressID
      AddressLine1
      AddressLine2
      City
      State
      ZIP
I want to write a query to return the following in the result set:

Code:
FirstName, LastName, MailAddressLine1, MailAddressLine2, MailCity, MailState, MailZIP, PhysicalAddressLine1, PhysicalAddressLine2, PhysicalCity, PhysicalState, PhysicalZIP
All of these fields would be in every returned record, whether a Physical Address or Mailing Address existed or not for each person.

Can anyone help me out be either posting a relevent example, or telling me what I should look for in my SQL book.

Thank you.

David