getting data from two xml files

[swatirs]

hi,
I have xml files for my db tables. Now I want to get data out of it the way I get data from db table using sql joins. Can i do that? how?
Pls help