Hi
And thanks for your time
I have been building up basic queries exactly as you suggested today.
I can get the information I want without a join but it is not easy to get
the informaton displayed as nicely.
Mascon did give me an error about alias's at one time, but to be honest I
didn't understand in what respect I had an alias - ie is it the new out put
table or what?!
I have tried several times to reconstruct the script I posted but it works
until the point I try to do the join!!!
Thanks for your time, I'll go now and play :-)
Regards
Sara
----- Original Message -----
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
To: "Sara" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 7:11 PM
Subject: Re: syntax problem
> > 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
>
>
---------------------------------------------------------------------
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
