Re: export mutiple tables data into a single xml

[Harald Groven]

Simple example of how to do this without use of scripting language (like PHP/ASP)

SELECT CONCAT(
'<employees>\n',
'<emplayeName>', P.name, '</emplayeName>',
'<companyName>', C.companyName, '</companyName>',
'\n</employees>'
) AS xmldata
FROM persons P, company C
WHERE P.company_id = C.id
;