Merge MySql table and a external XML to have them ORDER BY timestamp

[veghead]

From an external party we receive a constant updating XML newsfeed. We also have our own news in a MySql database. What i want to do is merge them both together so that i can sort them by timestamp and get a nice chronological order.So the ideal situation would be something like;\[code\]SELECT timestamp, titleFROM newsUNION ALLSELECT $story[0]->time AS timestamp, $story[0]->headline AS titleFROM xmlsource('local.xml')ORDER BY timestamp DESC\[/code\]Is this possible? Or is their any other quick way merging them and sorting them on timestamp? Thanks for any comments about this..