Okay, so I've got a ton of experience using MySQL but I've never actually mastered using JOINs.

Basically I have these:

community:
  • id
  • title


house:
  • lot_number
  • community (foreign key to community(id))
  • price
  • square_feet


floor_plan:
  • title
  • square_feet


Sort of like that, but with a lot of other tables and a lot of other fields.

What I'm trying to do is something like this:

Lot (lot.lot_number) at (community.title) features the (floor_plan.title) plan.

How would you suggest I go about doing something like this in the most efficient way possible? The system has a lot of inter-connecting parts so it gets pretty complicated at times.