[ cf-dev ] SQL question - brain a blank!

[Allan Cliff RedPro]

I have 4 tables.

people, peoplecars, peopleboats. peoplehouses.

I want to do a query on people which gives me the following list.

Person - CountCars - CountBoats - CountHouses
Mr Fred Bloggs - 10 cars - 0 boats - 1 house.

Thanks

Allan