General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
One select statement for a many to one relationship
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only