topic Joins in Application Development and Automation Discussions

topic Joins in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/joins/m-p/2710653#M628360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can i fetch data from 3 tables with a single select statement without using joins </P><P></P><P>thanks.</P><P>sagar</P></BODY></HTML> Tue, 21 Aug 2007 09:30:17 GMT Former Member 2007-08-21T09:30:17Z Joins https://community.sap.com/t5/application-development-and-automation-discussions/joins/m-p/2710653#M628360 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can i fetch data from 3 tables with a single select statement without using joins </P><P></P><P>thanks.</P><P>sagar</P></BODY></HTML> Tue, 21 Aug 2007 09:30:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/joins/m-p/2710653#M628360 Former Member 2007-08-21T09:30:17Z Re: Joins https://community.sap.com/t5/application-development-and-automation-discussions/joins/m-p/2710654#M628361 <HTML><HEAD></HEAD><BODY><P>HI sagar,</P><P></P><P></P><P>u create a view and use it as a single table</P><P>if ur view is view1</P><P>then use</P><P>select * from view1.</P><P></P><P>i think they is no other way for ur requirement</P><P><b></P><P>Regards,</P><P>Azhar</b></P></BODY></HTML> Tue, 21 Aug 2007 09:31:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/joins/m-p/2710654#M628361 Former Member 2007-08-21T09:31:21Z