VbzCart/queries/qryCustAddrs
Jump to navigation
Jump to search
Details
- Requires:
- REDIRECT Template:l/vc/table
- Used by:
- Notes: Any basic simple calculations not involving other tables can be added to this query as needed.
SQL
<mysql>CREATE OR REPLACE VIEW qryCustAddrs AS SELECT
*, NOT ((IFNULL(WhenAct,Now()) > Now()) OR (IFNULL(WhenExp,Now()) < Now())) AS isActive FROM cust_addrs;</mysql>