Related Left Outer Join Query Example

This SQL creates a query with a related left outer join:

SELECT A.PORTAL_NAME 
  FROM (PSMSGNODEDEFN A LEFT OUTER JOIN  PSPRDMDEFN B ON  B.PORTAL_NAME = A.PORTAL_NAME )

SOAP document:

<QAS_QUERY_SAVE_REQ_MSG>
  <RECORD>
    <RCDNUM>1</RCDNUM>
    <RCDNAME>PSMSGNODEDEFN</RCDNAME>
    <CORRNAME>A</CORRNAME>
    <JOINTYPE/>
    <JOINRCDALIAS/>
    <JOINFIELD/>
    <RCDSELECTNUM>1</RCDSELECTNUM>
  </RECORD>
  <RECORD>
    <RCDNUM>2</RCDNUM>
    <RCDNAME>PSPRDMDEFN</RCDNAME>
    <CORRNAME>B</CORRNAME>
    <JOINRCDALIAS>A</JOINRCDALIAS>
    <JOINFIELD>PORTAL_NAME</JOINFIELD>
    <JOINTYPE>RelatedLeftOuter</JOINTYPE>
    <RCDSELECTNUM>1</RCDSELECTNUM>
  </RECORD>
  <FIELD>
    <FIELDNUM>1</FIELDNUM>
    <FIELDNAME>PORTAL_NAME</FIELDNAME>
    <FIELDRCDNUM>1</FIELDRCDNUM>
    <DESCR>Portal Name</DESCR>
    <AGGREGATE_TYPE>None</AGGREGATE_TYPE>
    <HEADING_TYPE>RFT Short</HEADING_TYPE>
    <HEADING>Portal Name</HEADING>
    <COLUMNNUM>1</COLUMNNUM>
    <ORDERBYNUM>0</ORDERBYNUM>
    <ORDERBYDIR>Ascending</ORDERBYDIR>
    <FIELDSELECTNUM>1</FIELDSELECTNUM>
    <EXPRESSION_AS_FIELD>0</EXPRESSION_AS_FIELD>
  </FIELD>
  <CRITERION>
    <CRTNUM>1</CRTNUM>
    <CRTNAME>1</CRTNAME>
    <CRTHAVINGFLAG>False</CRTHAVINGFLAG>
    <CRTSELECTNUM>1</CRTSELECTNUM>
    <CRTNEGATION>False</CRTNEGATION>
    <CONDITION_TYPE>equal to</CONDITION_TYPE>
    <LEFT_PARENTHESIS_LEVEL>0</LEFT_PARENTHESIS_LEVEL>
    <RIGHT_PARENTHESIS_LEVEL>0</RIGHT_PARENTHESIS_LEVEL>
    <CRTEXP1TYPE>Field</CRTEXP1TYPE>
    <CRTEXP1TEXT>B.PORTAL_NAME</CRTEXP1TEXT>
    <CRTEXP1NUM>0</CRTEXP1NUM>
    <CRTEXP1RCDALIAS>B</CRTEXP1RCDALIAS>
    <CRTEXP1FIELD>PORTAL_NAME</CRTEXP1FIELD>
    <CRTEXP2RCDALIAS>A</CRTEXP2RCDALIAS>
    <CRTEXP2FIELD>PORTAL_NAME</CRTEXP2FIELD>
    <CRTEXP2TYPE>Field</CRTEXP2TYPE>
    <CRTEXP2TEXT>A.PORTAL_NAME</CRTEXP2TEXT>
    <CRTLOGICALOPER>not used</CRTLOGICALOPER>
    <CRT_BELONGSTO>B</CRT_BELONGSTO>
  </CRITERION>  
  <SELECT>
    <SELECTNUM>1</SELECTNUM>
    <PARENTSELECTNUM>0</PARENTSELECTNUM>
    <SELECTTYPE>Main</SELECTTYPE>
    <QRYDISTINCT>False</QRYDISTINCT>
  </SELECT>
  <QUERY_NAME>OJ_TRIAL</QUERY_NAME> 
  <DESCRIPTION>This is a query with a left outer join</DESCRIPTION> 
  <DESCRLONG>outer join example used for testing with QAS</DESCRLONG> 
  <QUERY_OWNER>Public</QUERY_OWNER> 
</QAS_QUERY_SAVE_REQ_MSG>