Help with a query

From: john <nospam_at_nospam.com>
Date: Fri, 21 Mar 2003 22:03:30 -0000
Message-ID: <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? Received on Fri Mar 21 2003 - 23:03:30 CET