Conditions too complex for XSL?

[MissyEd]

XML:
<dataset>
<official>
</official>
<unofficial>
</unofficial>
<aliases>
</aliases>
</dataset>
The official and unoffical nodes both contain TeamA, TeamB, Selection (numerical) and Index (numerical). Additionally the unofficial list has several Sources.

The aliases node containts Index, TeamName
Selection can be TeamA (1) or TeamB (2).

The major issues I have at the moment are:
The team names don't match directly and have to be resolved via the aliases list.
Not all teams are on the aliases list.
A team name can appear multiple times in the alias list (for example there are teams in different countries with the same name).
The unoffical list may have TeamA and TeamB in different positions to the official list i.e where the match is on neutral ground.
If the positions are reversed, the selection is also reversed.

Bearing that in mind, I need to produce an XML file from this XML that has only rows from the unoffical list where a match has been made to the official list on the correct Selection and the Indexes are different.

I'm more used to SQL queries and have only really done simple direct matches in XSL, so I'm very lost atm. Any pointers appreciated.

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

 

[tsuji]

With the description, I would think the forum would be hard to be seen helpful except for showing the sympathy for the project you've to substantiate.

 

[MissyEd]

Yes, it seems far too complex so I'm going to attempt to simplify it and keep it in SQL.

Thanks

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter