Enhancement Request - Select table of Join suggestions

After you type Inner Join , the popup appears. It has the table and suggested joins. The suggested joins can be selected. However, I would like to be able to hit enter on a table and have the table name output. Sometimes I have to do something non-standard on the join.

I don't understand the issue. Why cannot you select just the table line and press Enter to insert that table name alone?

	SysOp wrote:
	I don't understand the issue. Why cannot you select just the table line and press Enter to insert that table name alone?

I'm trying to reproduce what you are saying but it does not seem to allow for that?

http://screencast.com/t/THYgQVZAxAS

	SysOp wrote:
	I don't understand the issue. Why cannot you select just the table line and press Enter to insert that table name alone?

Yes, I would love to do that. It doesn't work that way though. SSMS at least.

Finally got a chance to see your video. Thanks for the clarifications. You are referring to ON keyword, not to JOIN, which is a step too late. If you simply type JOIN (any kind of JOIN, INNER, LEFT, RIGHT, OUTER, FULL, etc...) you get a similar prompt with suggested joins and join conditions and there you can select just the table. If you choose a condition (a combination of suggested column matches), SQL Assistant will generate and insert the entire join clause with the tables and all the matching primary key / foreign key columns. In comparison, the prompt for ON keyword suggests columns for the already entered table, you cannot use it to select a table. hope this makes sense..

SysOp wrote:

Finally got a chance to see your video. Thanks for the clarifications. You are referring to ON keyword, not to JOIN, which is a step too late. If you simply type JOIN (any kind of JOIN, INNER, LEFT, RIGHT, OUTER, FULL, etc...) you get a similar prompt with suggested joins and join conditions and there you can select just the table. If you choose a condition (a combination of suggested column matches), SQL Assistant will generate and insert the entire join clause with the tables and all the matching primary key / foreign key columns. In comparison, the prompt for ON keyword suggests columns for the already entered table, you cannot use it to select a table. hope this makes sense..

Well I'm not the OP so that was my video. Maybe I misinterpreted what he said.

But the way it sounds is that sometimes he's got joins that aren't in the suggestion list so he wanted to select just the table name so he could type just the dot and the column name, rather than tablename.columname for the ON clause?

No it was when I typed join. But I was using a non-dbo schema.

could you please describe step-by-step how to reproduce the issue?