Corelated Sub Queries

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Corelated Sub Queries

Rate Topic

Display Mode

Topic Options

Author

Message

AdiM

Posted 2/11/2008 12:13:28 AM

Forum Newbie

Group: Forum Members
Last Login: 2/11/2008 12:19:47 AM
Posts: 3, Visits: 3

How do Corelated Sub queries work? How do we identify and distinguish them from a normal sub query and how frequently are corelated sub queries used in practical applications.
Am new to teradata and it would be great if someone could walk me through the 'Corelated Sub query' concept with some simple explanatory codes.
Thanks .

Regards
Adi

Post #10538

LeoIssac

Posted 2/14/2008 3:01:35 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 5:54:22 PM
Posts: 173, Visits: 50

When an instance of outer relation(table) is also refered in the inner sub-query, the query is said to be co-related. example

select....
from
tableA A where fld1=(select fld2 from tableB B where B.fld3=A.fld4)

For every fld1 in the tableA, the subquery will be run based on condition B.fld3=A.fld4.The outer table is here co-related with the inner sub-query/sub-table

Leo Issac

"Wants to Learn More!"

Post #10594

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:32pm