-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Gary,
1. A subselect should only have one value (one row, one field).
2. If you will connect to the current row of the outer select, the
table of the outer select must have an alias.
SELECT "event_name", "first_name", "middle_initial", "last_name",
"sex", "age", "email", "place",
CASE
WHEN "age" BETWEEN 0 AND 18 THEN 'Youth'
WHEN "age" BETWEEN 19 AND 59 THEN 'Adult'
ELSE 'Senior'
END "Group",
CASE
WHEN "place" <= 3 THEN ( SELECT "finish" FROM "Ribbons"
WHERE "ID" = "a"."place" )
WHEN "place" >= 4 THEN ( SELECT "finish" FROM "Ribbons"
WHERE "ID" = "4" )
END "Finish",
CASE
WHEN "place" <= 3 THEN ( SELECT "ribbon" FROM "Ribbons"
WHERE "ID" = "a"."place" )
WHEN "place" >= 4 THEN ( SELECT "ribbon" FROM "Ribbons"
WHERE "ID" = "4" )
END "Ribbon"
FROM "Results" AS "a"
... would work.
Regards
Robert
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQIcBAEBAgAGBQJX/PhbAAoJELDKYwaoS9AI7CQQALCwbj3eMS15dglMvFrV9wK+
+DEj4O3MAR2q77g+Jfg6mRpJOzWOO6VPKDWcSLkJ8fE1PMEtRyeDgwohWDNjdTHI
o2WESahYWWBdQsAS2eo7w1CneFdIeqWVmH4Vm5zDeWyar904ys9Zb7RndV5a6IG6
NVR5i6tqCySTh7EjGQYWswOduK5HMQRDyh1dlV7cVlUlE/hAhumiHaTbdVs1z1wK
ltBmH/h5/Y7ScHzlkRCcF6pN5VnkGi20yVnRDjohqIQy8XZlmncaZLJp/DaG1U1z
2OqlGxdNTH3gY2Eoq1Fl/31WwAPvJwuxb0OMAMkucJBJv0cOFaUOkPcmSaKBoz1h
CPMiCskMC8DDlfnl3CxIW1jSMr0h5jGyj6WtGRRznqbhdqzIPcCiSRQNzL7Vmgmr
8VVJ9wCa2fEhHqPtbWSLDCj3rBD4iqyIbXje8Esc6FTwpzNUWE2BzdDC1fSuIJry
j/555xEdZ+FhT5UGbm0d37WLB5OxxUtW4UsnPsn7CcgkQQfChrD+c6FqEe+pj1Nt
aqfTVCSPTrTE6zX8mLbKlsweORVjc7Q0uelZuvhvGNJw1E+hJsuV0BLEe1pMpdna
Lbz7R7iGWGSn9NXsU+gwNGhAhzRj/a5Ir7oUOlxnFT/CzDM5pmouFFPBc026TOHL
YCIIbJculj0cp0LZObxj
=LO8G
-----END PGP SIGNATURE-----
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
