Help with this query
| From: | shaun | Date: | Fri, 21 Mar 2003 22:02:21 +0000 |
| Subject: | Help with this query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26548@lists.php.net to get a copy of this message | ||
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?