It doesn't return multiple recordsets, it returns one recordset made up from fields in multiple tables, but sometimes the same field name could be found in more than one table.