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 is the teradata different from oracle?

1164

What do you mean by fastexport in teradata?

1043

What are the multiload utility limitations?

1110

What type of indexing mechanism do we need to use for a typical data warehouse?

1225

What is stored procedure in teradata?

1083

What is the purpose of upsert command?

1258

What's the difference between timestamp (0) and timestamp (6)?

1250

In the Primary Index, what is the score of AMPs that are actively involved?

1124

What are the various indexes in teradata?

1094

Explain vproc in teradata?

1041

What do you mean by teradata intelliflex?

1167

What is spool space?

1220

What exactly do you know about catching in teradata?

1077

Highlight the differences between Primary Key and Primary Index.

1142

Why managing the data is important?

1056