Are you saying that any query containing parentheses fails? In that case sub selects won't work either.
> -----Original Message----- > From: James Fryer [mailto:[EMAIL PROTECTED] > Sent: 14 August 2003 10:07 > To: [EMAIL PROTECTED] > Subject: RE: CREATE TABLE, INSERT INTO with SELECT in parentheses > > > At 09:47 am 14/08/03, Jim Smith wrote: > >But why do you need the parentheses? > > This was a simplified query for example purposes. > > The real query looks more like > > (SELECT ...) UNION (SELECT ...) ORDER BY ... I repeat. Why do you need the parentheses? Union queries don't require them. > > I could rewrite this with subselects but I have found them to > be slower. > > My question is, why do the parentheses cause a syntax error > and is this a bug? > > Jim > -- > James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]