Hi there,
I have two rather simple queries, which I would to UNION, but somehow I always get an error message for the UNION ("ERROR: syntax error at or near "UNION"")
Each query selects the country name ("Switzerland" in this case), the most recent year in the table and its value.
What is wrong with it? Thanks for any hints!
SELECT
c.name,
d.year_start,
d.value
FROM
emissions_so2_total_rivm AS d
LEFT JOIN
countries AS c ON c.id = d.id_country
WHERE
((c.iso_2_code = 'CH') OR (c.iso_3_code = 'CH'))
ORDER BY
d.year_start DESC
LIMIT 1
UNION ALL
SELECT
c.name,
d.year_start,
d.value
FROM
pop_density AS d
LEFT JOIN
countries AS c ON c.id = d.id_country
WHERE
((c.iso_2_code = 'CH') OR (c.iso_3_code = 'CH'))
ORDER BY
d.year_start DESC
LIMIT 1
____________________________________________________________________
Stefan Schwarzer
Lean Back and Relax - Enjoy some Nature Photography
Appetite for Global Data? UNEP GEO Data Portal:
____________________________________________________________________