Hello,
Back again after several months. Played fine with SQL and most (with a little help from forummembers) went well.
I now have made a view with results of several years for all the people in the database.
I can query the view to get the three winners, sorted decending on Winstperc. The result looks like this:
Seizoen Naam Winstperc
2006/07 Jim 1,0909
2006/07 Bill 1,0896
2006/07 William 1,0879
And that's exactly what I want to know but I need it like this:
Seizoen Nr1 Nr2 Nr3
2006/07 Jim Bill William
Looking through the threads I got some nice ideas but...
I tried it with IF and with Case but never succeeded.
So, I think I'm overlooking something. Please show me the way?
Thanks in advance and excuse my use of English (my Dutch is better)
Bauke
Back again after several months. Played fine with SQL and most (with a little help from forummembers) went well.
I now have made a view with results of several years for all the people in the database.
I can query the view to get the three winners, sorted decending on Winstperc. The result looks like this:
Seizoen Naam Winstperc
2006/07 Jim 1,0909
2006/07 Bill 1,0896
2006/07 William 1,0879
And that's exactly what I want to know but I need it like this:
Seizoen Nr1 Nr2 Nr3
2006/07 Jim Bill William
Looking through the threads I got some nice ideas but...
I tried it with IF and with Case but never succeeded.
So, I think I'm overlooking something. Please show me the way?
Thanks in advance and excuse my use of English (my Dutch is better)
Bauke