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 server? I use Visual Basic for accessing mysql server. > > Thank You very much > Bruno Not that I knew the real answer but I suspect that Access just retrieves the results in a temporary table and then finishes the job by including the results table with a join to the rest of the tables as required. Or maybe it wraps the subquery in VB/VB script and loops through the subselect and does the select in every loop. /h --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
