OUTPUT: 1, a, d 2, b, NULL 3, NULL, c

tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?

Question Posted / subhash

3 Answers
8962 Views
Infotech, I also Faced
E-Mail Answers

Answer Posted / subhash

OUTPUT:

1, a, d
2, b, NULL
3, NULL, c

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

explain about citrix scheduling tool in datastage

2508

what are the errors,warnings in datastage

2762

What are stage variables?

1251

On which interface you will be working as a developer?

1101

What could be a data source system?

1096

how to delete one row in target dataset

3162

Difference between sequential file and data set?

1259

how to add a new records into source?

2051

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2659

How do you import and export data into datastage?

1292

Differentiate between data file and descriptor file?

1099

What are the primary usages of datastage tool?

1128

What is the precedence of stage variables,derivations, and constraints?

1126

Can you explain tagbatch restructure operator?

1214

how to abort the job its matain duplicates?

2621