Obtaining single datasets from multiple datasets

[sravanthi]

Hi ,

I have a situation where i Have to combine all the datasets into single datset and generate one single xml file.

I have tried using dummy column on all the datastes and joined(left outer join) but the data is not comming in exact manner.

I need to obtain all the data without any modification.
I 1st dataset conatins a,b column.2nd datatset contain c,d column i need the output as a,b,c,d columns.

Can anyone suggest some solution for my situation.

thanks

[kumar_s]

You cannot do this unless you have a common column (key) in all the three. If not, you have to try with dummy column, as what you have did. Which will result in cross product. Again you need to remove the recoreds based on your requirements. Which is most ineffecient way of doing.