Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Give the syntax of Inner,outer Join?"

Answer Posted / ravi ranjan

syntax of inner join:-
select t1~field1 t1~field2 t2~field3 t3~field4
INTO CORRESPONDING FIELD OF TABLES <INTERNAL TABLE>
FROM TABLE1 AS t1 inner join table2 as t2 on
t1~field1(key field) = t2~field2(key field).

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many types of tables exist and what are they in data dictionary?

1226


What do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary

1024


How to call other programs?

1067


How the transaction that are programmed by the user can be protected?

1103


How do you get the number of lines in an internal table? How to use a specific number occurs statement?

952


there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?

2209


How can we access the correction and transport system? : abap data dictionary

1052


Which bdc you prefer? : abap bdc

1315


What are the user interfaces of interactive lists?

1027


What are matchcodes?

973


What is the difference between leave transaction and call transaction?

1056


how to read the standard field value in your custom program.

1473


when do you need to create an internal table with header line ? and with out a header line?

2009


What is the use of the raising exception?

989


Explain different types of locks?

1051