[RESOLVED] Using JOIN in MySQL
Okay, so I've got a ton of experience using MySQL but I've never actually mastered using JOINs.
Basically I have these:
- community (foreign key to community(id))
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.