[SOLVED] LEFT OUTER JOIN and GROUP BY

[ari_aaron]

There are 2 tables: users and flags.

User    |  level  | flag

21    2          Access

21    4          TEST

3      3          reaafa

And

UID | Username

21    ari_aaron

2      ben

3      read

5      test

76    fafa

 

I am using this query:

SELECT users . * , SUM( flags.level ) AS flags FROM users LEFT OUTER JOIN flags ON flags.user = users.UID  GROUP BY flags.user

 

However, only 1 user with no flags is returned together with the users with flags. I thought OUTER meant all rows?!? Removeing the GROUP BY fixes it.

 

 

How do i do this?

 

Thanks,

 

Ari

[Barand]

GROUP BY users.UID

[ari_aaron]

Thanks

 

That was simple enough :S