distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

SARNOLD-KIT posted 1 month ago in General

Please see attached screenshot;

1 attachment(s):
  • heidi-results-bug
ansgar posted 1 month ago

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

kalvaro posted 1 month ago

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.