Forum Discussion
SQL WHERE Statement
I am trying to write a query where the date used could be one of 3 depending on if the dates are valid or not. In the screenshot below I have managed to create a field PODate to contain the corre...
Thanks, that gives me just what I wanted
Helen
Helen
WHERE is a pre-processor command, while SELECT and ORDER by are post-processor commands.
You can not use alias defined in post in a pre command.
You can not use alias defined in post in a pre command.