MySQL vprašanje - redundanca recordov

Spoštovani!

Imam sledeč query:

SELECT weblife.bwFacilities.Id, weblife.bwFacilities.Name,
												 weblife.bwFacilities.Address, weblife.bwCities.ZipCode,
												 weblife.bwCities.Name, weblife.bwCities.IdCountry,
												 weblife.bwCountries.Name, weblife.bwCountries.Id,
												 weblife.bwCountries.IdContinent, weblife.bwContinents.Id,
												 weblife.bwContinents.Name
										  FROM weblife.bwFacilities, weblife.rlResortsHaveFacilities,
										  	   weblife.bwCities, weblife.bwCountries,
											   weblife.bwContinents, weblife.bwResorts
										  WHERE weblife.bwFacilities.Id=weblife.rlResortsHaveFacilities.IdFacility
										  		AND weblife.bwFacilities.IdCity=weblife.bwCities.Id
												AND weblife.bwCities.IdCountry=weblife.bwCountries.Id
												AND weblife.bwCountries.IdContinent=weblife.bwContinents.Id
										  ORDER BY weblife.bwFacilities.Id;

ki mi vrne naslednje rezultate:

  000001 Pizzerija Dobra Vila, Vodnikova 8, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000001 Pizzerija Dobra Vila, Vodnikova 8, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000001 Pizzerija Dobra Vila, Vodnikova 8, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000002 Grand Hotel Union Executive, Miklo?i?eva 1, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000002 Grand Hotel Union Executive, Miklo?i?eva 1, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000002 Grand Hotel Union Executive, Miklo?i?eva 1, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000003 Grand Hotel Union Business, Miklo?i?eva 3, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000003 Grand Hotel Union Business, Miklo?i?eva 3, 1000 Ljubljana, Slovenia-Europe (FACILITY)
  000003 Grand Hotel Union Business, Miklo?i?eva 3, 1000 Ljubljana, Slovenia-Europe (FACILITY)

Zakaj mi vsak record izpiše 3x. Vem, da mora biti kretenska napaka, ampak je ne najdem in ne najdem, prosim za pomoč!

hmm, ne razumem, cak, bom poguglu!!

Tabelo bwResorts nimaš v joinu.

Tega orodja žal ne poznam, poznam pa SQL. In tvoj SQL ti vrne kartezični produkt na bwResorts, ker ni joina za to tabelo.

jao, seveda, sj je logično!! tkoj grem probat, hvala!!!!!!!!