KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Im having a hard time building the triple join query. I have three tables: House: house ID(key) | Address | personID | Person: personID (key) | Name | Address | Images: // of house imageID (key) | personID | url | I would like to limit the results to 5 . I want to query house address-es (main), it's owner name & address, and one picture of the owner. Note: There are up to 3 images of every person (3 rows in image table), but just one is necessary, doesnt matter which one.
Tags (comma-separated)
Save Edits
Cancel