Thank Nathan a lot!
We already figured out the NOT IN part. However your extra 'change other
city' is also great!
-Bruce
melinate wrote:
>
> Don't know if you already found a solution, but here is what the SQL would
> look like... I imagine the HQL would be similar..
>
> Here is how to get jus
Don't know if you already found a solution, but here is what the SQL would look
like... I imagine the HQL would be similar..
Here is how to get just the "other" users:
SELECT user.* FROM user WHERE user.city NOT IN (SELECT city.name FROM city
WHERE state = 'CA')
Here is how to get all users an
