topic Re: SAP Query question in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-question/m-p/2477891#M557949 <HTML><HEAD></HEAD><BODY><P>n/a</P></BODY></HTML> Mon, 23 Jul 2007 19:17:12 GMT Former Member 2007-07-23T19:17:12Z SAP Query question https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-question/m-p/2477890#M557948 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a SAP query. It joins the SKB1 and SKA1 table, meaning that related alternative account numbers shall be printed if any for each record in SKB1. These two tables are joined by outer join.</P><P></P><P>The problem is the output. It only outputs the SKB1 records that have an alternative account, not the others </P><P></P><P>Ex.</P><P></P><P>G/L Account</P><P></P><P>Comp.code GL acc. Alternative print status</P><P></P><P>01 6005 7007 Printed</P><P>02 6005 Blank Not printed</P><P>03 6005 7007 Printed</P><P></P><P>etc.</P><P></P><P>What am I doing wrong ?</P></BODY></HTML> Tue, 26 Jun 2007 13:17:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-question/m-p/2477890#M557948 Former Member 2007-06-26T13:17:55Z Re: SAP Query question https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-question/m-p/2477891#M557949 <HTML><HEAD></HEAD><BODY><P>n/a</P></BODY></HTML> Mon, 23 Jul 2007 19:17:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-question/m-p/2477891#M557949 Former Member 2007-07-23T19:17:12Z