I would like to have something of this kind (put in commun the date )
<TEST>
<TableID>
<ID>1</ID>
<roomName>Suite</roomName>
<TableRoom>
<ID>1</ID>
<Date>31.07.2005</Date>
<A> 100</A>
<B>462</B>
</TableRoom>
<TableRoom>
<ID>1</ID>
<Date>31.08.2005</Date>
<A>411</A>
<T/ableRoom> There is no info for B
this is my xquery code
<TEST>
{
for $i in doc("transformXQUERY.xml")//TableID/TableRoom,
$TableRoom in $i,
$a in $TableRoom/A
(:$b in $TableRoom/B
where $a/Date = $b/Date:) I have a problem here
order by $TableRoom/ID
return
element { name($root) }
{
for $TableID in $root/*
return
element {name($TableID)} {
(
$TableID/ID,
$TableID/roomName,
for $date in $dates
return
<TableRoom>
{
<date>{$date}</date>,
for $room in $TableID/TableRoom
where $room//Date = $date
return
element {name($room)} {
$room/A/text() | $room/B/text()
}
}
</TableRoom>
)
}
}