Re: Help with a query

"john" <nospam_at_nospam.com> wrote in message news:PZLea.1200$yF3.90097_at_stones.force9.net...
> Hi,
>
> I have the following tables in my database:
>
> CREATE TABLE WMS_Allocations (
> Allocation_ID int(11) DEFAULT '' NOT NULL auto_increment,
> Project_ID int(11) DEFAULT '0' NOT NULL ,
> User_ID int(11) DEFAULT '0' NOT NULL ,
> PRIMARY KEY (Allocation_ID),
> );
>
> CREATE TABLE WMS_Projects (
> Project_ID int(11) DEFAULT '' NOT NULL auto_increment,
> Project_Name varchar(255) ,
> PRIMARY KEY (Project_ID)
> );
>
> CREATE TABLE WMS_User (
> User_ID int(11) DEFAULT '' NOT NULL auto_increment,
> User_Username varchar(100) DEFAULT '' NOT NULL ,
> User_Password varchar(100) DEFAULT '' NOT NULL ,
> User_Name varchar(100) DEFAULT '' NOT NULL ,
> User_Type int(11) DEFAULT '0' NOT NULL ,
> PRIMARY KEY (User_ID),
> UNIQUE User_Username (User_Username)
> );
>
> How can i select users from WMS_User where no users have been allocated to a
> particular project - seems a little tricky with MySQL?

SELECT U.User_ID
FROM WMS_User AS U

            LEFT OUTER JOIN
            WMS_Allocations AS A
            ON U.User_ID = A.User_ID

Regards,
jag Received on Fri Mar 21 2003 - 23:08:14 CET