Forum Discussion
mjsystemss
Sep 14, 2024Copper Contributor
HELP WITH MY WHERE CLAUSE REQUIREMENT
Hello , I need help with examining this query. I have this query below and my requirements. The First Requirement is 1. If appselection !='notice to process' and notetxt is NULL in last month show...
rodgerkong
Iron Contributor
Do you need two different result set? With requirement 1, show acct and notetext. With requirement 2, show acctid.
In your SQL sample, WHERE clause has two same parts of conditions that split by 'OR', what is the purpose?
Give some sample rows and show the result your want, will supply more help to understand your question.
In your SQL sample, WHERE clause has two same parts of conditions that split by 'OR', what is the purpose?
Give some sample rows and show the result your want, will supply more help to understand your question.
rao67
Sep 16, 2024Copper Contributor
this info help full to my knowladge