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
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:
- 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 contains a separate row for each module
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