Hi
Thanks very much for your informative post Sinsia.
I rather thought that this was the whole purpose of this mailing list?
If I had all the answers and indeed the skills, I would not have posted to
the list in the first place.
I have been trying to find information in the web, and from books which sets
out in a very basic form how to actually do the different kinds of *join*
and trying to find out what it is with my script that is wrong, but to no
avail.
If you know that my problem is, or can point me to a site which will give me
the help I need, then I would be very grateful.
I am after all trying to learn mysql and am a beginner.
Regards
Sara
----- Original Message -----
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 11:22 AM
Subject: Re: syntax problem
> Sara writes:
> > Hi
> >
> > I have compiled a report using Mascon only to find I can't export it to
any other software I have! Great report but not much good to me as it is
:-(
> >
> > (I'm not well versed in php yet, otherwise this might be an issue)
> >
> > However, I did get the sql query script and thought I could run it in
Mascon itself and export the data table to excel which would do for now.
> >
> > However, this syntax appears to produce exactly the query I want in the
report tool but doesn't appear to work when cut and past into the sql query
option in mascon.
> >
> > Can you tell me where the query is wrong please? Im only just learning
sql and it looks ok to me!
> >
> > ***
> > select handicap_results.date,
> > handicap_results.victor,
> > handicaps.icq_nick,
> > handicaps.provisional,
> > handicaps.handicaps,
> > from handicap_results 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,
> > ****
> >
> > Thanks very much in anticipation!
> >
> > Sara
>
> You err in the use of the alias.
>
> Please improve your basic SQL skills.
>
> --
> Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
---------------------------------------------------------------------
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