how to create a view using two tables in different schemas in ibm db2 : I have got two tables T1 and T2 . T1 is present in schema S1 and T2 is present in schema S2. I am using DB2 database. I also have two queries  for fetching  data from T1 and T2 respectively. 

Now, I have a requirement where I need to create a view and get the combined data of two queries in that view.

I have searched a lot on internet for creating a view on different schemas in DB2, but couldn't get a right solution.

Please help.

