Shlomi Fish wrote:
>I have three tables: clubs, users and permissions. clubs contains a
>Club_ID (an integer). users contains a User_ID. Permissions contains both
>as well as a Subjects field (a boolean).
>
>Now, a user is allowed to edit the data associated with a club if he has a
>record in the permissions table (with the appropriate User_ID and
>Club_ID). He is allowed to edit the subjects if the Subjects field is set.
>
>Now, I want to make one query that given a User_ID will return a list of
>all the clubs in clubs with the following three fields:
>
>1. Club_ID
>2. Whether a record exist in Permissions.
>3. If so, whether the Subjects flag is set (or if 2 is false -
>undetermined)
>
>I am using MySQL 3.23.47, but can possibly switch to PostgreSQL.
>
>
You need to do a left outer join on the clubs and permissions table, something which
MySQL 3 does not support. 4.1 should do it, but I have only 4.0 installed and I can't
make it it the query Arik came up with. I don't know if PostgreSQL can do it.
Credits: Arik Baratz, our resident SQL guru came up with the correct query. if you're
still interested I can send it.
--
Oded
::..
Friends should be like throw pillows;
Comfortable to lean on, and unmindful of the weight.
--Ginger Eastham
=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]
