A Gentle Introduction to

SQL

NEW.

These questions have been submitted by users.



Is it possbile to use variables in SELECT to allow forms to set conditional (WHERE, etc.) parameters?
I am using Access and have a number of forms, reports and queries that differ only slightly (e.g. Invoice vs Past Due Invoice) and could consolidate and simplify maintenance if variables in SELECT were possible.
postgres variations:
None

access
db2
mysql
oracle
postgres
sqlserver