Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mironline
Starting Member
4 Posts |
 Posted - 2007-06-08 : 15:11:43
|
| Dear Friends ; I have 2 tables as follow : [ users ] user_id --> [ key ]user name , ......-----------------------------------------------------------[ project ]project_id --> [key]user_id --> [key]I assign the users to projects with these tables.how can I select un-assigned users for specific project ?Thank you.A.M |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-08 : 15:23:23
|
| homewrok question? what have you tried so far?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-08 : 16:37:05
|
| It is not our "duty" to solve homework questions. Please show us what you have tried so far. Also, you'll need to provide a data example of what you want.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Select!