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

INNER JOIN ON[space] inserts the wrong candidate.

When entering a select statement formatted like this:

select *
from [Person].[Address] AS a
inner JOIN [Person].[Contact] AS c
on

the candidate list appears defaulting to the "All common objects". The keyword "ON" is listed on the third line. Pressing the space bar at this point inserts

soh.[OnlineOrderFlag] , [Sales].[SalesOrderHeader] AS soh

rather than the intended keyword "ON". It seems foolish to have to press the down arrow key twice then Enter to select a 2-letter keyword. I have the screenshots and a copy of the log file but can't figure out how to attach them to this post.

Mark
myuabov
0

Comments

1 comment

Sort by
  • Lionel
    Thanks for the feeback. I have added that bug to our bug tracking database. I looks like our parser is being caused some problems with thouse new lines. The reason that small keywords like ON are in the candidate list are to make sure that if the candidate list pops up when you are typing ON it doesn't select a table begining with on and let you acidentally insert that instead.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.