First, I really love the tool. I just started using it but already know it is going to come in handy.
When creating an Update query using a From statement to utilize data from multiple tables, SQLPrompt displays the column names instead of allowing table selection after the FROM statement.
For Example:
Update Cust
Set CustId =2
FROM Cust INNER JOIN CustOrders.....
the prompts after the FROM are fields from the Cust table, not table names.
When creating an Update query using a From statement to utilize data from multiple tables, SQLPrompt displays the column names instead of allowing table selection after the FROM statement.
For Example:
Update Cust
Set CustId =2
FROM Cust INNER JOIN CustOrders.....
the prompts after the FROM are fields from the Cust table, not table names.