The Web Server Environment - Database Processing: Fundamentals, Design, and Implementation - page 511

(a) XML Schema

(b) Graphical representation of the XML Schema

Figure 11-58
Customer and artist
Interests

/* *** SQL-Query-CH11-04 *** */
SELECT CUSTOMER.LastName AS CustomerLastName,

CUSTOMER.FirstName AS CustomerFirstName,

TRANS.TransactionID, SalesPrice,

WORK.WorkID, Title, Copy,

ARTIST.LastName AS ArtistName

FROM CUSTOMER, TRANS, [WORK], ARTIST

WHERE CUSTOMER.CustomerID = TRANS.CustomerID

AND TRANS.WorkID = WORK.WorkID

AND WORK.ArtistID = ARTIST.ArtistID

ORDER BY CUSTOMER.LastName, ARTIST.LastName

FOR XML AUTO, ELEMENTS;