View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 11:29 AM
Pavel Lepin
 
Posts: n/a
Default Re: Help with 3 tables select


FFMG <FFMG.2zlyes@no-mx.httppoint.com> wrote in
<FFMG.2zlyes@no-mx.httppoint.com>:
> I have a table of users
>
> TABLE_A = username, userID
>
> They are member of one _or more_ group
>
> TABLE_B = userID, grouID
>
> Each group has a set of one _or more_ permissions
>
> TABLE_C = grouID, permission
>
> So to get the permissions for one user...


....you should use JOINs. Read about JOIN syntax in MySQL
Reference Manual.

--
"I can't help but wonder if you... don't know a hell of a
lot more about practically every subject than Solomon ever
did."
Reply With Quote