>Hi All,
>
>We have a table that holds all of our addresses (address_id), we have an other table that holds 3 references for that address table, the main address, the early address and the late address (address_id, am_address_id, and pm_address_id)
>
>We need to get all the addresses stored in the people table (address_id, am_address_id, and pm_address_id) with the full address info.
>
>We need it to be ANSI complinat because this could go to a SQL back-end, and VFP back-end or and other db back-end.
>
>Can this be done?
>
>Thanks,
>Beth

Would something like

SELECT people.*,ad.*,am.*,pm.* ;
  FROM people ;
  LEFT OUTER JOIN address ON people.address_id = address.addres_id;
  LEFT OUTER JOIN address am ON people.am_address_id = am.address_id;
  LEFT OUTER JOIN address pm ON people.pm_address_id = pm.address_id

do the trick?