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
8732 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

Can you explain kafka connector?

1245

How to clean the datastage repository?

1071

Have you used Unstructured data?

1269

Where do the datastage jobs get stored?

1149

What are the job parameters?

1161

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1833

project Steps,hits, Project level HArd things,Solved methods?

2065

Describe the main features of datastage?

1039

What is the flow of loading data into fact & dimensional tables?

1014

how to delete one row in target dataset

3065

Is it possible to query a hash file?

1953

What is job control?

1035

Difference between data warehousing and olap?

1044

What are the functionalities of link partitioner and link collector?

952

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2386