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 is the purpose of using case expression in teradata?

577

Name the five phases that come under MultiLoad Utility.

591

what is sysdba and sysdbc ? which has high priority ?

3376

Explain the new features of teradata?

573

In general, how do you optimze any sql in teradata?

555

What is the basic syntax for teradata select statement?

583

Different phases of multiload?

596

How is MLOAD Teradata Server restarted after execution?

655

What is teradata? Also, list out some of the primary characteristics of teradata.

583

What happens in a conflict? How do you handle that?

628

any one answer me how they can analyzing the project using data ware housing?

2032

What is the use of stored procedures in teradata?

570

How to load specific no.of records using bteq, or fastload,or multiload

1323

What is teradata? What are some primary characteristics of teradata?

552

Which is faster fastload or multiload?

600