Just tried MS SQL server 2000. I can type in browser:
http://localhost/mydb?sql=select * from dept, emp
where dept.deptno=emp.dept.no for xml auto&root=List
then, I will get XML:
<List>
<dept id='10' name='Sales'>
<emp id='10' name='King' salary='5000'/>
<emp id='20' name='John' salary='200'/>
</dept>
<dept id='20' name='Account'>
<emp id='30' name='Peter' salary='2000'/>
</dept>
...
</List>
The nesting of joined result is automatic, and I found
that it is very useful. so is there any similar tool
that can be used to get similar result?
Thanks
Evan
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
