1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SELECT u.idterrain, u.nomterrain, (select first( idproprio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=1) AS idproprio1, (select first(nompropio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=1) AS nomproprio1, (select first( idproprio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=2) AS idproprio2, (select first(nompropio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=2) AS nomproprio2, (select first( idproprio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=3) AS idproprio3, (select first(nompropio) from
(SELECT a.idproprio, a.idterrain, a.nompropio, (select count(idproprio) from proprio where idproprio<=a.idproprio and idterrain=a.idterrain) AS cprop
FROM proprio AS a) where idterrain=u.idterrain and cprop=3) AS nomproprio3,
(select first(idnature) from
(SELECT (select count(idnature) from natur where idnature<=b.idnature and idterrain=b.idterrain) AS ordnat, b.idterrain, b.idnature
FROM natur AS b) where idterrain=u.idterrain and ordnat=1) as nature1,
(select first(idnature) from
(SELECT (select count(idnature) from natur where idnature<=b.idnature and idterrain=b.idterrain) AS ordnat, b.idterrain, b.idnature
FROM natur AS b) where idterrain=u.idterrain and ordnat=2) as nature2,
(select first(idnature) from
(SELECT (select count(idnature) from natur where idnature<=b.idnature and idterrain=b.idterrain) AS ordnat, b.idterrain, b.idnature
FROM natur AS b) where idterrain=u.idterrain and ordnat=3) as nature3
FROM terrains AS u; |
Partager