How can we help you today? How can we help you today?

Prompt shows wrong fieldnames with EXCEPT or INTERSECT

When expanding a wildcard in a EXCEPT or INTERSECT query it shows the fields from the first SQL statement when you expect the field from the second statement.

SQLPrompt version 7.1.0.118
CREATE TABLE [dbo].[tblTabel1] (
		tbl1Field1 BIGINT IDENTITY(1,1) NOT NULL
		, tbl1Field2 nvarchar(10)
		, tbl1Field3 nvarchar(10))


CREATE TABLE [dbo].[tblTabel2] (
		tbl2Field1 BIGINT IDENTITY(1,1) NOT NULL
		, tbl21Field2 nvarchar(10)
		, tbl2Field3 nvarchar(10))

		
SELECT * FROM [dbo].[tblTabel1]
EXCEPT
SELECT [tblTabel1].[tbl1Field1]
     , [tblTabel1].[tbl1Field2]
     , [tblTabel1].[tbl1Field3] FROM [dbo].[tblTabel2]
Maurice
0

Comments

5 comments

Sort by
  • Aaron L
    Hi Maurice,

    Thanks for reporting this! It looks like some of the changes we made in the 7.1 beta caused this knock on, I'll look into getting it fixed for you now.

    Thanks,
    Aaron.
    Aaron L
    0
  • Maurice
    Hi Aaron,

    Great, I will check it in the next Beta.

    Just want to say that you all do a great job with beta en new functions! My job is so much easier with SQL-Prompt ;)

    Maurice
    Maurice
    0
  • Aaron L
    Thanks Maurice - that's great to hear! :)
    Aaron L
    0
  • Aaron L
    Hi Maurice,

    We've just shipped a new beta build (7.1.0.144) which has a fix for this issue.

    Thanks!
    Aaron.
    Aaron L
    0
  • Maurice
    Hi Aaron,

    Installed the new build and it's fixed!.

    Thanks,

    Maurice
    Maurice
    0

Add comment

Please sign in to leave a comment.