jamie_pattison
Well-known member
- Joined
- Sep 9, 2008
- Messages
- 116
- Programming Experience
- Beginner
A company has produced our data in XML format. Ive managed to extract the data from it, in code but since the data contains two tables i need to establish how to ensure the contents from the second table are in line with the data in the first table? An example to illustrate this
Data from table 1
ID Name Position
1 George Bush President
2 Madonna Artist
3 UB40 Artists
4 Spice Girls Artists
Data from table 2
ID Title
1 Mr
2 Mrs
4 Ms
In effect all i need is the data to be returned as
ID Name Position Title
1 George Bush President Mr
2 Madonna Artist Mrs
3 UB40 Artists
4 Spice Girls Artists Mrs
How would i code this?
Data from table 1
ID Name Position
1 George Bush President
2 Madonna Artist
3 UB40 Artists
4 Spice Girls Artists
Data from table 2
ID Title
1 Mr
2 Mrs
4 Ms
In effect all i need is the data to be returned as
ID Name Position Title
1 George Bush President Mr
2 Madonna Artist Mrs
3 UB40 Artists
4 Spice Girls Artists Mrs
How would i code this?