I'm loading a number of fields form Lotus Notes using ODBC. After the load statement I have the following Select Statement:
SQL
FROM
"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');
SELECT *
FROM
"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');
SELECT *
SELECT *
FROM
"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');
The result unfortunately shows no sign of filtering. It is as if the Where part of the statement was not there. I get records whose asset types are neither PC or Laptop and that have Lease Terms = 6.
Don't SQL statements work to there full capicity when used in this context,
