;SQL SELECT: Last updated on May 2, 2006
The following query select *all column_attributes from
local database with condition of Left's utility account number must be matched
to Right's utility account number, and another condition to be matched is Left's
social security number must not be matched to #session's social security number
in Right, and so on; <> is NOT
;
Select * from local_database where Utility_Account_Number = '#trim(utility_account_number)#' and SSN<>'#session.Social_Security_Number#' AND pay_status = 'YES' and (pay_type = 'X' OR pay_type = 'XX' OR Pay_type = 'USD')
|
|
|
 |
|
