I have the following data:
<Subjects> <Subject> <Id>1</Id> <Name>Maths</Name> </Subject> <Subject> <Id>2</Id> <Name>Science</Name> </Subject> <Subject> <Id>2</Id> <Name>Advanced Science</Name> </Subject> <Subject> <Id>500</Id> <Name>XYZ</Name> </Subject> <Subject> <Id>1000</Id> <Name>ABC</Name> </Subject> </Subjects>
and:
<Courses> <Course> <SubjectId>1</SubjectId> <Name>Algebra I</Name> </Course> <Course> <SubjectId>1</SubjectId> <Name>Algebra II</Name> </Course> <Course> <SubjectId>1</SubjectId> <Name>Percentages</Name> </Course> <Course> <SubjectId>2</SubjectId> <Name>Physics</Name> </Course> <Course> <SubjectId>2</SubjectId> <Name>Biology</Name> </Course> </Courses>
and I want to be able to get the subject
elements with 500
and 1000
, because they don't appear in the 2nd XML document.
How do I do this in the most efficient way possible (bare in mind I have about 750 subjects, each with 120 courses)?
No comments:
Post a Comment