JOIN Statement alternatives

Former Member — Fri, 21 Dec 2007 11:19:18 GMT

Hi folks, I have a problem with a join statement.basically i am trying to read GL Document data.I have the statement below but when it searches in table PPOIX it only retrieves the first match it finds based on pp0ix-runid = ppdix-runid and pp0ix-tslin = ppdix-linum.What i want to do is get all tslin for each linum found in ppdix. if i leave out pp0ix-tslin = ppdix-linum then i will get every line per runid but i just want lines that are found in ppdix.

SELECT DISTINCT ppdit~hkont

ppdit~kostl

ppoix~pernr

ppoix~betrg

ppoix~waers

INTO TABLE gt_gl_lines

FROM ppdit

JOIN ppdix ON ppdix_{docnum = ppdit}docnum

AND ppdix_{doclin = ppdit}doclin

JOIN ppoix ON ppoix_{runid = ppdix}runid

AND ppoix_{tslin = ppdix}linum

WHERE ppdix~runid = gs_gl_docs-runid

AND ppdit~docnum = gs_gl_docs-docnum

AND ppdit~kostl = l_kostl_new.

Edited by: Damien Kesle on Dec 21, 2007 12:21 PM

Re: JOIN Statement alternatives

Former Member — Fri, 21 Dec 2007 11:32:17 GMT

Did you try by removing DISTINCT key word from your select statment????

Re: JOIN Statement alternatives

Former Member — Fri, 21 Dec 2007 11:50:13 GMT

The addition DISTINCT forces a sort on the database server.You should therefore only use it if you are really expecting duplicatesin the result set.

Regards,

Mohan.

topic Re: JOIN Statement alternatives in Application Development and Automation Discussions

JOIN Statement alternatives

Re: JOIN Statement alternatives

Re: JOIN Statement alternatives