ODBC Complex Query

rc = SQLExecDirect(hstmt, "SELECT first_name, last_name, " +
                   "ssn, address, city, state, zip " +
                   "FROM employees", SQL_NTS);
 
/* fetch data using complex query */
...
rc = SQLExecDirect(hstmt, "UPDATE employees SET address = ? " +
                   "WHERE first_name = ? AND last_name = ? " +
                   "AND ssn = ? AND address = ? AND city = ? AND " +
                   "state = ? AND zip = ?", SQL_NTS);