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
Dear Team,
This question may be best in Hibernate forum. However I give it try here
since many are knowledgeable and helpful in this forum. I use appfuse 1.9.4
with WW2. My problem is,
There is City field in user table, some users are in big cities like LA, San
Francisco and others in not well-k
