Multiple resultsets is a common term. Where a resultset is a table basically.

SQL Server (since 2005) can actually even have multiple active resultsets on a single connection. Assume same is true for most other database servers.