Interested to Buy Any Domain ? << Click Here >> for more details...
Give the syntax of Inner,outer Join?"
- 7 Answers
- 35236 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
In ALV reporting when u execute your report which event gets triggered.
What is the difference between sy-tabix and sy-index? Where it is used?
Explain what is sequence of event triggered in report?
How the transaction that are programmed by the user can be protected?
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?
can any one answer these questions 1)How do you convert non-character field to character field? 2)How do you work with semi colon separated files? 3)why cant we use normal function module for data transfer? 4)what is the structure of CTU-PARAMS? 5)can we use transfer dataset to transfer data in internal table?
What is value table?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
What is dynpro? what are its components ?
What are system variable in abap?
How does the system handle roll areas for external program components?
Explain how to Handle the internal tables in ABAP?
Why do we declare a method of a class final? What can be the purpose? Give a scenario.
What are the function modules used in f4 help?
Will 50,000 records be uploaded directly into APP's Server?
