目前我正在为我运行此查询
SELECT `Sheet1$`.ACCT_CODE, `Sheet1$`.ACCTG_DATE, `Sheet1$`.AGENT_NO, `Sheet1$`.BAL_BOOK_CODE, `Sheet1$`.JRNL_ID_NO, `Sheet1$`.PRODUCT_CODE, `Sheet1$`.SOURCE_SYSTEM_ID, `Sheet1$`.`SUM(DR_CR_AMOUNT)`
FROM `Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.BAL_BOOK_CODE='5092') AND (`Sheet1$`.ACCT_CODE Not Like '%H%') AND (`Sheet1$`.AGENT_NO='943776') OR (`Sheet1$`.BAL_BOOK_CODE='509A') AND (`Sheet1$`.ACCT_CODE Not Like '%H%') AND (`Sheet1$`.AGENT_NO='943776')
ORDER BY `Sheet1$`.ACCT_CODE
查询给出的结果仅限于 AGENT_NO='943776'
而我想要显示的结果
- ACCT_CODE 不像"%H%"和
- 如果AGENT_NO='943776',则BAL_BOOK_CODE='509A'或BAL_BOOK_CODE='5092'
- 显示所有其他AGENT_NO
选择Sheet1$
。ACCTG_DATE,Sheet1$
.JRNL_ID_NO,Sheet1$
.ACCT_CODE,Sheet1$
.SOURCE_SYSTEM_ID,Sheet1$
.AGENT_NO,Sheet1$
.PRODUCT_CODE,Sheet1$
.BAL_BOOK_CODE,Sheet1$
.SUM(DR_CR_AMOUNT)
从C:Documents and SettingsAmit JoshiDesktopBook1.xlsx
.Sheet1$
Sheet1$
其中 ( Sheet1$
.ACCT_CODE不像"__H")和(Sheet1$
。AGENT_NO<>'943776')
全部联合
选择Sheet1$
。ACCTG_DATE,Sheet1$
.JRNL_ID_NO,Sheet1$
.ACCT_CODE,Sheet1$
.SOURCE_SYSTEM_ID,Sheet1$
.AGENT_NO,Sheet1$
.PRODUCT_CODE,Sheet1$
.BAL_BOOK_CODE,Sheet1$
.SUM(DR_CR_AMOUNT)
从C:Documents and SettingsAmit JoshiDesktopBook1.xlsx
.Sheet1$
Sheet1$
其中 ( Sheet1$
.BAL_BOOK_CODE='5092') 和 ( Sheet1$
.AGENT_NO='943776') 或 ( Sheet1$
.BAL_BOOK_CODE='509A') 和 ( Sheet1$
.AGENT_NO='943776')