Thx's Fred...
as soon as I sent the email and re-read it again... I spotted the 'as' alias
table reference to the table, was actual a reserved word,..causing the error :)
thx's again.
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solu
Mike Blezien said:
>
> I've been looking at this SQL query a dozen times or more, but keep
> getting a syntax error message, Query:
>
> SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
> name,aw.siteid,ai.email,as.username,as.status
> FROM affiliate_info ai,affiliate_signup as,aff
On Tue, Jan 20, 2004 at 04:10:44PM -0600, Mike Blezien wrote:
> I've been looking at this SQL query a dozen times or more, but keep getting
> a syntax error message, Query:
>
> SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
> name,aw.siteid,ai.email,as.username,as.status
> FRO
Try:
SELECT FF.name AS thename,
MAX(FF.label) AS thelabel,
F.name AS fieldsname
FROM regformfields as FF
INNER JOIN regfields as F
ON (FF.name = F.Name)
WHERE FF.label != ''
GROUP BY FF.name, F.name
I don't think you can include the ORDER BY F.saveorder (anot
What you had looks fine except the date...change what you had to:
AND date >= '2002-03-17'; # date needs quotes around it
Should work.
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 8:49 AM
To: mysql list (choose midget)
Subject:
> I'm trying to figure out a query that will tell me the total number of
> people in our house email file that physically opted out in the last
> week. I'm a bit of a mysql newbie as you can tell...
>
> This is the general concept, though it doesn't seem to work:
>
> select count(id) from conta
AND date >= "2002-03-17";
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 10:49 AM
To: mysql "list (choose midget)
Subject: Query syntax help
I'm trying to figure out a query that will tell me the total number of
people in our house email