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

How to eliminate product joins in a teradata sql query?

1085

What does sleep function does in fast load?

1207

Can we collect statistics on multiple columns?

1122

What are the updated features of teradata?

1089

Describe primary index in teradata. And what are the available primary index types?

1041

What is the maximum number of dml can be coded in a multiload script?

1155

What is meant by a Least Cost Plan?

1106

What are teradata utilities?

1155

What is TPD?

1418

What are types of partition primary index (ppi) in teradata?

1100

What is bteq utility in teradata?

1024

What is node? How many nodes and amps used in your previous project?

1153

why use references rather than pointers in the public api, particularly for arguments which are modified?

1053

During the Display time, how is the sequence generated by Teradata?

1120

Explain how spool space is used.

1111