I'm not sure but try the post

HOW TO: SQL Server data to XML data?

if u just modify the query according to multiple tables, u'll get the results of multiple tables as well.

Try it out, this may be helpful for u.

Regards,

Ejaz.