Queries on SQL,Teradata

Jayalakshmi · New User Joined: 02 Sep 2005 Posts: 26 Location: Hyderabad

Hi all,

I have some couple of questions;

(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?

Regards,
Jaya.

anamikak · New User Joined: 10 May 2006 Posts: 64 Location: Singapore

Hi Jayalakshmi,

1) your question is not clear. But if i have understood correctly, then a clue for your first question is db2 utlilities.

If you want to ask generic questions like your second and third questions, then it is better to find out from Google.

referto links below for your second and third:

http://en.wikipedia.org/wiki/Teradata

http://www.dbazine.com/db2/db2-disarticles/gulutzan9

Anamika