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.