Multiple Select Query: Heidi Uses First Table Name for All Results

Please see attached screenshot;

You need to separate the queries with semicolon, so HeidiSQL can find the right table name in them.

I presume you are using SQL Server. FYI, not using statement delimiter is apparently deprecated and will be removed in some to-be-determined future version:

• Features Not Supported in a Future Version of SQL Server

The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.

[...]

Not ending Transact-SQL statements with a semicolon.