I may be misremembering this but I think ODBC does allow for more than one table to be returned at a time? But it has been nearly 30 years since I messed with

I may be misremembering this but I think ODBC does allow for more than one table to be returned at a time? But it has been nearly 30 years since I messed with that API. I think it has to do with stored procedures and that they sometimes can return more than one table. Maybe someone with more recent exp in it can chime in.