First, I have never used MySQL and do not know if OLE DB provider for MySQL supports multiple SELECT statements in one command.
Second, if OLE DB provider for MySQL supports multiple SELECT statements in one command, you shoud use Execute method of the Command object or Open method of the Recordset object to execute them. See MSDN topic "NextRecordset Method (ADO)" for more information about executing more than one SELECT statements in one command and getting the result.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000) br>
VB (.NET) - what other language do you need in the whole Universe?...