> I rather thought that this was the whole purpose of this mailing list?
You are right both in your inquiry and in your reply to Sinisa.
It is not his usual way, though, I was astonished myself.
I think most is ok. Try
select handicap_results.date,
handicap_results.victor,
handicaps.icq_nick,
handicaps.provisional,
handicaps.handicaps,
from handicap_results
inner join handicaps handicaps
on (handicaps.icq_nick = handicap_results.victor)
group by handicap_results.victor,
handicaps.handicap,
handicaps.provisional,
handicap_results.date
I omitted some commas. A good way to find out is to construct a
very basic query first which works and then make it more complex
step by step until you reach the error condition. Then you will
see exactly what it is that needs change. You should have the fix
in a few minutes yourself with this technique.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
