SQL to fetch object-data and table-data combined

Monday 23 January 2006 4:54:18 am

I have 191 Country objects in my eZ publish installation. I want to make a MySQL table with country statistics. In the Country class I have defined an integer attribute that holds an uniqe indentifer for each country. The same identifer I want to use in the table with statistics.

My question: Is it possible to make a SQL-query that fetches all the statistics from one country, something like

SELECT * FROM eZ_country_objects, statistical_table
WHERE eZ_country_objects.ID = statistical_tabel_ID

???

http://blog.thematicmapping.org
http://www.globalis.no