Hi, i want to provide two different tables as below
Table1:
id Genre
bk1011 Computer
bk1121 Computer
bk1031 Fantasy
Table2:
Genre id
Computer bk1011
bk1121
Fantasy bk1031
<?xml version="1.0"?>
<catalog>
<book id="bk1011">
<author>Gambardella, Matthew</author>
<title>XML Developer's Guide</title>
<genre>Computer</genre>
<price>44.95</price>
<publish_date>2000-10-02</publish_date>
<description>An in-depth look at creating applications
with XML.</description>
</book>
<book id="bk1121">
<author>Galos, Mike</author>
<title>Visual Studio 7: A Comprehensive Guide</title>
<genre>Computer</genre>
<price>49.95</price>
<publish_date>2001-04-16</publish_date>
<description>Microsoft Visual Studio 7 is explored in depth,
looking at how Visual Basic, Visual C++, C#, and ASP+ are
integrated into a comprehensive development
environment.</description>
</book>
<book id="bk1031">
<author>Corets, Eva</author>
<title>Maeve Ascendant</title>
<genre>Fantasy</genre>
<price>5.95</price>
<publish_date>2000-11-17</publish_date>
<description>After the collapse of a nanotechnology
society in England, the young survivors lay the
foundation for a new society.</description>
</book>
... View more