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