What Is The Use Of 'outerjoin'?

1.	What Is The Use Of 'outerjoin'?
Answer» With the use of OUTER join you can join the tables EVEN there is no entry in all the tables USED in the view. In case of inner join there should be an entry in all the tables use in the view. With the use of outer join you can join the tables even there is no entry in all the tables used in the view. In case of inner join there should be an entry in all the tables use in the view.

Answer»

With the use of OUTER join you can join the tables EVEN there is no entry in all the tables USED in the view. In case of inner join there should be an entry in all the tables use in the view.

With the use of outer join you can join the tables even there is no entry in all the tables used in the view. In case of inner join there should be an entry in all the tables use in the view.

Discussion

No Comment Found

Related InterviewSolutions

What Are User Exits And Name An Example Where One Could Be Used In The Fi/co Modules?
What Is The Report Painter?
What Is The Legacy System Migration Workbench (lsmw) And When Would You Use It In Your Sap Fi/co Rollout ?
Explain The Purpose Of The Following Sap R/3 Co Tables: Coep, Cska, Ce1xxxx?
Explain The Purpose Of The Following Sap R/3 Fi Tables: Bseg, Bkpf, Glt0
What Is The Special Purpose Ledger And What Would Be Some Reasons For Using It ?
When Defining A New Ledger In The Special Purpose Ledger, How Can You Retrospectively Populate Fi Data For A Previous Fiscal Year ?
What Are 'commitment' Line Items In Co ?
What Is A Company Code ? Describe Its Relationship With A Controlling Area?
What Is Stored In Table T001 ?

What Is The Use Of 'outerjoin'?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment