> The question is what does Access do in order to > perform subqueries on MySQL via
>MyODBC driver > since 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
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
> m
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 diff
