topic join in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/join/m-p/3157015#M750954 <HTML><HEAD></HEAD><BODY><P>what is diff b/w innner join and outer join?plz tell</P></BODY></HTML> Mon, 24 Dec 2007 12:28:22 GMT Former Member 2007-12-24T12:28:22Z join https://community.sap.com/t5/application-development-and-automation-discussions/join/m-p/3157015#M750954 <HTML><HEAD></HEAD><BODY><P>what is diff b/w innner join and outer join?plz tell</P></BODY></HTML> Mon, 24 Dec 2007 12:28:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join/m-p/3157015#M750954 Former Member 2007-12-24T12:28:22Z Re: join https://community.sap.com/t5/application-development-and-automation-discussions/join/m-p/3157016#M750955 <HTML><HEAD></HEAD><BODY><P>inner join : this extracts records which are present in all the tables involved in the join.kind of intersection between the tables.</P><P></P><P>outer join : it retrieves all the records fromm all the tables involved in the join.kind of union between the tables.</P></BODY></HTML> Mon, 24 Dec 2007 12:48:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/join/m-p/3157016#M750955 Former Member 2007-12-24T12:48:42Z