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 default access rights in teradata?

1124

What is bteq script in teradata?

1156

How will you solve the problem that occurs during update?

1055

Explain how spool space is used.

1077

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

987

What can be achieved by using the teradata rdbms?

1038

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

1031

how can we analyze the locks ?

2132

Explain amp in teradata?

1086

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

What is meant by a Least Cost Plan?

1061

what are the day to day activities of teradata DBA ?

5825

What is spool space? Why do you get spool space errors?

1020

Explain the term 'foreign key' related to relational database management system?

1043

Describe the between keyword in teradata?

1040