Revision 46517 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/test/resources/org/gvsig/fmap/dal/store/h2/usecases/arena2/testMultipleExpansionOfCalculatedField.sql
| testMultipleExpansionOfCalculatedField.sql | ||
|---|---|---|
| 32 | 32 |
"PUBLIC"."ARENA2_CONDUCTORES"."OTRA_INFRAC_COND", "PUBLIC"."ARENA2_CONDUCTORES"."EXTRA", |
| 33 | 33 |
"PUBLIC"."ARENA2_ACCIDENTES"."KM" AS "AccKm0", |
| 34 | 34 |
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 100) AS "AccKm1",
|
| 35 |
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 222) AS "AccKm2"
|
|
| 35 |
("PUBLIC"."ARENA2_ACCIDENTES"."KM" * 222) AS "AccKm2",
|
|
| 36 |
"PUBLIC"."ARENA2_ACCIDENTES"."KM" |
|
| 36 | 37 |
FROM "PUBLIC"."ARENA2_CONDUCTORES" |
| 37 | 38 |
LEFT JOIN "PUBLIC"."ARENA2_ACCIDENTES" ON ( ("PUBLIC"."ARENA2_CONDUCTORES"."ID_ACCIDENTE") = ("PUBLIC"."ARENA2_ACCIDENTES"."ID_ACCIDENTE") )
|
| 38 | 39 |
ORDER BY "PUBLIC"."ARENA2_CONDUCTORES"."LID_CONDUCTOR" ASC LIMIT 15 |
Also available in: Unified diff