 |
| | |||||||||||||||||||||||||||
| | Thread Tools | Search this Thread | Display Modes |
 12-Jul-2006, 13:05 | #11 |
| Registered Forum User Ducati in my Blood  Posts: 4,379 Join Date: Dec 2004 Location: Dorking, Surrey. Mood: What a wonderful world. Nope, no bikes share the same numbers... [code]SELECT DD1.firstname, DD1.lastname, DD1.raceNumber, DD2.firstname, DD2.lastname, DD2.raceNumber FROM dd_standing_racers DD1, dd_standing_racers DD2 WHERE DD1.raceNumber = DD2.raceNumber AND (DD1.firstname != DD2.firstname OR DD1.lastname != DD2.lastname)[/code] returned firstname lastname raceNumber firstname lastname raceNumber Tim Howard 5 David Reilly 5 Mark Hill 36 Andrew Johnson 36 Andrew Johnson 36 Mark Hill 36 James Thompson 10 Chris Wood 10 Chris Wood 10 James Thompson 10 Jean-Paul Hackett 69 Marcus Blackburn 69 Eric Howe 69 Marcus Blackburn 69 Marcus Blackburn 69 Jean-Paul Hackett 69 Eric Howe 69 Jean-Paul Hackett 69 Paul Martin 39 Doug Clemmans 39 Doug Clemmans 16 Graeme Melvill 16 Doug Clemmans 39 Paul Martin 39 Marcus Blackburn 69 Eric Howe 69 Jean-Paul Hackett 69 Eric Howe 69 David Reilly 5 Tim Howard 5 Graeme Melvill 16 Doug Clemmans 16  | |
Threaded Mode