i think..By using joins we can get required records.based on your requirem

I want to write one query
How to get Matched records and unmatched records in table?

Question Posted / gowthami

Answer Posted / gowthami

i think..By using joins we can get required records.based on
your requirements we should choose left outer join or right
outer join

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are differences between teradata and ansi session modes in teradata?

1222

What are the uses of bynets in multi-node systems?

1078

Explain the types of join supports by teradata?

1047

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1030

Explain and compare pros and cons of start schemas?

1153

How would you load a very large file in teradata in general?

1092

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1159

What is bteq script in teradata?

1214

Explain teradata vs. Redshift?

1080

Explain the teradata primary index mechanics in detail with a diagram.

1043

What are the joins in teradata and how many types of joins are there in teradata?

1061

What are the various indexes in teradata?

1104

What do you mean by fastexport in teradata?

1050

Differentiate database data and data warehouse data?

1163

What is the purpose of upsert command?

1266