topic Re: Select data from three tables in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-data-from-three-tables/m-p/2838011#M664601 <HTML><HEAD></HEAD><BODY><P>sth like this:</P><P></P><P> SELECT</P><P> P~pspnr...</P><P> INTO CORRESPONDING FIELDS OF itab</P><P> FROM ( proj AS p INNER JOIN jest AS J</P><P> ON P<SUB>OBJNR = J</SUB>OBJNR )</P><P> join TJ30T as t</P><P> on T~ISTAT = J-TSTAT</P><P> </P><P> WHERE T~spras = 'EN'</P><P> and T~ISTAT like 'E%'.....</P><P></P><P></P><P>A.</P></BODY></HTML> Tue, 02 Oct 2007 06:53:16 GMT andreas_mann3 2007-10-02T06:53:16Z Select data from three tables https://community.sap.com/t5/application-development-and-automation-discussions/select-data-from-three-tables/m-p/2838010#M664600 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Tables :PROJ-JEST-TJ30T Target Field:TXT04</P><P></P><P>PROJ-PSPNR--&gt; PROJ-OBJNR =JEST-OBJNR + JEST-INACT = «blank»</P><P>JEST-STAT = (TJ30T-ISTAT = E* (we have to take only E*)+ TJ30T-SPRAS = EN) --&gt;TJ30T-TXT04</P><P>We can have some status to display here, please concatenate and separate them by a coma.</P><P></P><P>can you give me suggestion to fill that requirement?</P><P></P><P>Regards</P><P>Subbu</P><P></P></BODY></HTML> Mon, 01 Oct 2007 09:56:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-data-from-three-tables/m-p/2838010#M664600 Former Member 2007-10-01T09:56:18Z Re: Select data from three tables https://community.sap.com/t5/application-development-and-automation-discussions/select-data-from-three-tables/m-p/2838011#M664601 <HTML><HEAD></HEAD><BODY><P>sth like this:</P><P></P><P> SELECT</P><P> P~pspnr...</P><P> INTO CORRESPONDING FIELDS OF itab</P><P> FROM ( proj AS p INNER JOIN jest AS J</P><P> ON P<SUB>OBJNR = J</SUB>OBJNR )</P><P> join TJ30T as t</P><P> on T~ISTAT = J-TSTAT</P><P> </P><P> WHERE T~spras = 'EN'</P><P> and T~ISTAT like 'E%'.....</P><P></P><P></P><P>A.</P></BODY></HTML> Tue, 02 Oct 2007 06:53:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-data-from-three-tables/m-p/2838011#M664601 andreas_mann3 2007-10-02T06:53:16Z