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.

mysql
Edit
Report