Re: MySQL subquery that works

2002-11-25 Thread John Ragan
The question is what does Access do in order to perform subqueries on MySQL via MyODBC driversince it is obvious that they work? access contains its own sql engine, so when you link the mysql tables into it, you were then running access queries. What can I do, but I do not want to use

MySQL subquery that works

2002-11-24 Thread Bruno Batarelo
Greetings! I am aware that MySQL does not support subqueries. I have a 3 gb large database of bibliographic records. Database is designed by a model that is accepted by almost every library system, but there is one problem. When searching that database, nested queries are needed and there's a

Re: MySQL subquery that works

2002-11-24 Thread R. Hannes Niedner
On 11/24/02 4:30 PM, Bruno Batarelo [EMAIL PROTECTED] wrote: The question is what does Access do in order to perform subqueries on MySQL via MyODBC driver since it is obvious that they work? What can I do, but I do not want to use access database as a layer between my application and mysql