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