Re: are MySQL Queries limited to they ahdere to Ansi SQL?

2001-08-20 Thread Ian Barwick
On Saturday 18 August 2001 14:37, Darragh Duffy wrote: > > Hi Folks > > below is a seltion of queries all doing very similar things I have run all > on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So > does this suggest that MySQL is not fully compliant with Ansi SQL? > >

are MySQL Queries limited to they ahdere to Ansi SQL?

2001-08-18 Thread Darragh Duffy
Hi Folks below is a seltion of queries all doing very similar things I have run all on Oracle 7 and 8i and all work fine. but only number 2 works in MySQL. So does this suggest that MySQL is not fully compliant with Ansi SQL? The problem seems to lie in the fact that the embedded select does