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 > FROM affiliate_info ai,affiliate_signup as,affiliate_website aw
AS is a reserved word. > WHERE aw.siteid = 1000 > AND ai.affilid = as.affilid AND aw.affilid = ai.affilid > > what is wrong with this query syntax ?? the syntax error is suppose to be > in this area: > `affiliate_website aw WHERE aw.siteid = 1000`.... > A bit before that. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]