-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

stefaan.lhermitte@agr.kuleuven.ac.be schrieb:
> Dear mysql-ians,

Hi

>
>...
> FROM vgt.NDVI AS NDVI
> INNER JOIN vgt.B AS B
> USING (id)
> INNER JOIN vgt.v_ecoclim AS eco
> USING (id)
> INNER JOIN vgt.v_vcf2001 AS vcf
> USING (id)
> ,
> (vgt.meta_gsc AS refmgsc

Whats this here? Seems to be a cross join. How do you combine the 3
combined tables with the ones below?

> INNER JOIN vgt.gsc AS refgsc
> ON refgsc.gsc_XX = refmgsc.id)
> INNER JOIN vgt.geo AS refgeo
> ON refgeo.id = refgsc.id
> INNER JOIN vgt.B AS refB
> ON refgeo.id = refB.id
> INNER JOIN vgt.v_ecoclim AS refeco
> ON refgeo.id = refeco.id
> INNER JOIN vgt.v_vcf2001 AS refvcf
> ON refgeo.id = refvcf.id
> INNER JOIN (vgt.gba AS refgba
> INNER JOIN vgt.meta_gba AS refmgba
> ON refgba.gba_XX = refmgba.id)
>...


What indices are set?

Regards
Stefan
>...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.1 (MingW32)

iD8DBQFEIgPxyeCLzp/JKjARAvOnAKDHXpMZhPuSBy574mu8S161EIOKTACgwsYh
PgSa+xHKWPq1aN7K7EVNmVA=
=IX8L
-----END PGP SIGNATURE-----