krishna,

"Then you can create a table using all the attributes from the first one, or second one or both."

I was able to merge the two databases together.. no problem but the thing is, if i go to the isoft query, i am not able to see any attributes from the gateway quary. So I am not able to mix attributes from both tables. I dont have access to it now, I will try again tomorrow. If i still have trouble, hope u will help. You are lifesaver. :)