try using QSqlQueryModel or call QSqlTableModel::setFilter(), only passing the where clause