o_sessions GROUP BY iuser;
+--+--+
| iuser | isession | ssession
+--+--+
|41 |2 | wanted
|42 |4 | wanted
|43 |6 | wanted
+--+--+
Mike
mysql
- Original Message -
From: "Matthew Scarrow"
Add the sSession field and put in the not wanteds and wanteds you will see that the 3
rows your query returns is the first ones in the list per iUser that are the not
wanteds. The query somehow needs to select the second ones. This is where the problem
comes in.
-- Original Message ---
From: "Robo" <[EMAIL PROTECTED]>
> Well, by now i have found a way to work around the problem,
> still the problem is not solved, you may want continue thinking about it:
>
> start with this:
> iSession iUser sSession
> -- -- -
> 1 41 no
>
