How to Retrieve data from unrelated tables?
Here is the scenario:
I have 2 tables:
- Table ‘User’ - fields: name, objectID
- Table ‘UserPets’ - fields: pets, userObjectID
- Table ‘pets’ - related to table ‘UserPets’
Given a pet data record, how can retrieve the name field of table ‘Users’, based on the record in ‘UserPets’
Please don’t ask me why the tables are designed such. Assume I can’t change how the database is designed, how do I achieve what I need?
Thanks and bunch!