(1) Suppose that I have 16 different tables and I have to retrieve a set of data based on Where Conditions using 1st 4 tables and again retrieve another set of data based on Where conditions using next 4 tables and so on..
After this i need to merge all these 4 sets of data into a single dataset with just one column as a common entity.
I want to do all this as a single Query.. Any suggestions on how to do this...
(2) Any inputs about Inline View?
(3) Any Inputs about Teradata?