First, you want to get an answer for every module, so you must use
modules LEFT JOIN permissions
to get a row for every module. You see? The table with missing rows (no
row for Bob/module3 in permissions) goes on the right.
When the table on the right does not have a matching row, the LEFT JO
- Original Message -
From: "David T." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 17, 2004 2:33 PM
Subject: Problems with Left Join query
> I am building a database with permissions for different modules. The
> permissions table cont
On Fri, 17 Sep 2004 11:33:04 -0700 (PDT), David T. <[EMAIL PROTECTED]> wrote:
> I am building a database with permissions for different modules. The
> permissions table contains a separate row for each module/user combination,
You didn't say, but if you're using PHP you might find this of use:
h
I am building a database with permissions for different modules. The
permissions table contains a separate row for each module/user combination, and
lists the add/mod/del permissions for that module. So, for example, user 'bob'
might have add and del rights for 'module1', add only rights for 'modul
