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')

 

 

Page Top