Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question about creating a specific SELECT Statement

I am trying to create a SELECT statement where I use a date range for the same date column, I am having a difficult time creating an AND for the same column I thought maybe you guys could help, here is the XML I have so far.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_JDBC_TRDHEADER_REQ xmlns:ns0="http://citgo.com/JDBC_to_CSL">

<STATEMENT>

<TABLENAME ACTION="SELECT">

<TABLE>qa_citgo_baseline.trd_header</TABLE>

<ACCESS>

<TRADE_NUM/>

<DEAL_NAME_STR/>

<COUNTERPART_COMPANY_NUM/>

<TRADE_TYPE_CD/>

<STRATEGY_NUM/>

<TRADE_INPUT_DT/>

<TRADE_DT/>

<ACCOUNTING_CLASS_CD/>

</ACCESS>

<KEY>

<TRADE_DT compareOperation="GTEQ">01-Jan-2008</TRADE_DT>

</KEY>

<KEY1>

<TRADE_DT compareOperation="LTEQ">08-Jan-2008</TRADE_DT>

</KEY1>

</TABLENAME>

</STATEMENT>

</ns0:MT_JDBC_TRDHEADER_REQ>

Is there anyway to do an AND instead of an OR.

Thanks

Not what you were looking for? View more on this topic or Ask a question