Newbie - JOIN multiple tables (1 Viewer)

[danb]

Hi,

I have the following four tables:

=============================

tblLocation

Id | Location
_____________
1 | London
2 | Birmingham
3 | Leicester

=============================

tblType

Id | Type
_____________
1 | Flat
2 | Maisonette
3 | Bungalow

=============================

tblStatus

Id | Status
_____________
1 | Sold
2 | Under offer
3 | For sale
=============================

tblProperties

Id | LocationId | TypeId | StatusId
___________________________________
1 | 2 | 1 | 3
2 | 3 | 1 | 2
3 | 1 | 2 | 3

=============================


Question is, what is the best way to join these tables? Is it best to actually do an INNER JOIN or just do a select with multiple WHERE clauses?

If the former, how do I actually do this? I've joined two tables before, but not more than this??

Any help would be much appreciated, thanks...

 

[danb]

I think I've found the solution actually, using multiple LEFT JOINs.