Give the syntax of Inner,outer Join?"
- 7 Answers
- 31019 Views
- Genpact, HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / navneet
inner join :
select P~<fieldname> d~<fieldname> into corresponding
fields of table <internaltable> from ( <table> as p inner
join <table> as d on <join condition> and <cond>.
outer join:
select P~<fieldname> d~<fieldname> into corresponding
fields of table <internaltable> from ( <table> as p left
outer join <table> as d on <join condition> and <cond>.
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What is the use of table maintenance allowed?
How will you insert record in a sorted table
What are advantages and disadvantages of logical data base
Are you familiar with all steps for setting up a workflow?
Explain get cursor field?
How do you activate a function exit?
What are the two ways for restricting the value range for a domain? : abap data dictionary
the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....
What is a variable in the sap abap?
What is a currency factoring technique?
What is the difference between Check and Continue?
How do you populate data into a multiple line field? : abap bdc
what is the difference between Blocked ALV and interactive ALV?
What is the use of the raising exception?
Explain the different types of data dictionary objects?
