Please see attached screenshot;
Multiple Select Query: Heidi Uses First Table Name for All Results
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:
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.
Please login to leave a reply, or register at first.