Re: Confusion over multiple table joins

2005-11-01 Thread Michael Stassen
Barry wrote: Can someone plaese help? I have three tables 1st is a collection of propertys, 2nd is a list of facilities(98 in total) and the third is a list of property id's corresponding to the facilities id's offered at each property, The query I am running: 'SELECT' '`'.$type.'`.`id`,' '`'.$t

Re: Confusion over multiple table joins

2005-11-01 Thread Jigal van Hemert
Barry wrote: Can someone plaese help? I have three tables 1st is a collection of propertys, 2nd is a list of facilities(98 in total) and the third is a list of property id's corresponding to the facilities id's offered at each property, The query I am running: 'SELECT' '`'.$type.'`.`id`,' '`'.$t

Confusion over multiple table joins

2005-11-01 Thread Barry
Can someone plaese help? I have three tables 1st is a collection of propertys, 2nd is a list of facilities(98 in total) and the third is a list of property id's corresponding to the facilities id's offered at each property, The query I am running: 'SELECT' '`'.$type.'`.`id`,' '`'.$type.'`.`name`,'