sql table search / php sort
Posted: Fri Sep 19, 2008 11:07 am
G'day guys.. just a quick q.
I've got the following table below with taskID and staff as an example.
The ID has a 1:M relationship with it..
My q. is.. how can i search these to find duplicate staff (all staff from one task) working on a 2nd task ( again, all staff on the same task) ??
example. task 1 & 4 have the same staff workin on 2 seperate projects..
I dont have any code to show, because it's all been so useless ive scrapped it...
ID | Staff
1 | bob
1 | sally
1 | gary
2 | gary
2 | michelle
2 | rick
2 | justin
3 | bob
3 | sally
3 | rick
4 | bob
4 | sally
4 | gary
can some1 please help??? this happens to be a crutial part of my project.. LOL
thankyou VERY much in advance to any1 who replys
I've got the following table below with taskID and staff as an example.
The ID has a 1:M relationship with it..
My q. is.. how can i search these to find duplicate staff (all staff from one task) working on a 2nd task ( again, all staff on the same task) ??
example. task 1 & 4 have the same staff workin on 2 seperate projects..
I dont have any code to show, because it's all been so useless ive scrapped it...
ID | Staff
1 | bob
1 | sally
1 | gary
2 | gary
2 | michelle
2 | rick
2 | justin
3 | bob
3 | sally
3 | rick
4 | bob
4 | sally
4 | gary
can some1 please help??? this happens to be a crutial part of my project.. LOL
thankyou VERY much in advance to any1 who replys