When combining "AND" and multiple "OR" in SQL statements we use Parenthesis. Example;
"SELECT * FROM soline WHERE Status != 'C' AND (OrdNbr LIKE 'TR%' OR OrdNbr LIKE 'O%' OR OrdNbr LIKE 'RP%')".
How is this achieved in the Daily Order Report?
When simply adding the "Or" in the Boolean for more than 2 lines, the rows returned ignore the first boolean (" != 'C' ")
The goal is to list all Open Orders, Transfer Orders, and Replacement Orders in the same report.
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (