Re: OT:SQL syntax error in mySQL

2002-12-06 Thread Jann VanOver
From: "Trace" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, December 04, 2002 3:09 PM > Subject: OT:SQL syntax error in mySQL > > >> Hi everybody, >> >> I have just switched a cf site from using a MSAcces

Re: OT:SQL syntax error in mySQL

2002-12-04 Thread Trace
l Message - From: "Trace" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 3:09 PM Subject: OT:SQL syntax error in mySQL > Hi everybody, > > I have just switched a cf site from using a MSAccess database to mySQ

OT:SQL syntax error in mySQL

2002-12-04 Thread Trace
Hi everybody, I have just switched a cf site from using a MSAccess database to mySQL . The following query produces and error now (did work in MSAccess): SELECT t.transID, a.authorID, g.groupID, ts.transName FROM (tbl_authors a INNER JOIN tbl_groups g ON