|
|
 next
|
  Subject: SQL/XML Error
Author: lee martindale
Date: 29 Mar 2006 05:05 PM
|
I am trying to do a simple two table join. I can get it to work in base sql but when I try adding the XMLELEMENT all I get are errors.
this is from the pubs MS SQL Server database.
SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "au_fname",a.authors.au_id),
XMLELEMENT(name "au_lname",a.authors.au_lname),
XMLELEMENT(name "au_fname",a.authors.au_fname),
XMLELEMENT(name "phone",a.phone)
XMLELEMENT(name "royaltyper",b.royaltyper)
FROM pubs.dbo.author a, pubs.dbo.titleauthor b
where a.authors.au_id = b.titleauthor.au_id
|
 top
|
  Subject: SQL/XML Error
Author: Minollo I.
Date: 29 Mar 2006 05:18 PM
|
Try this:
SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "au_fname",a.au_id),
XMLELEMENT(name "au_lname",a.au_lname),
XMLELEMENT(name "au_fname",a.au_fname),
XMLELEMENT(name "phone",a.phone),
XMLELEMENT(name "royaltyper",b.royaltyper)
)
FROM pubs.dbo.authors a, pubs.dbo.titleauthor b
WHERE a.au_id = b.au_id
|
|
|
|
