Provides intelligent code completion for SQL Server editors.
Moderators: David Atkinson, Anu Deshpande, Luke Jefferson
when suggesting the final join conditions for the following
join tableB on tableA.Aid = tableB.Aid
join tableC on tableB.Bid = tableC.Bid
join tableD on .......
SQL Prompt tries only to find matches between tableD and tableC, although in this case there is a link between tableA and tableD (infact there is even a FK relationship between the two)
- Posts: 70
- Joined: Tue Apr 07, 2009 12:46 pm
- Location: UK
Many thanks for your email.
This is the way currently SQL Prompt is designed to behave.
We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3530.
It will be reviewed by product manager and than marked for the release.
I will update you as soon as it is incorporated.
- Posts: 692
- Joined: Mon Apr 20, 2009 3:53 pm
- Location: Cambridge
It would be a huge help if SQL Prompt did this. This seems to be a big oversight, as many of our SQL queries do not just join to the previous table. Prompt SQL had provided this functionality. Thank you.
- Posts: 31
- Joined: Fri May 05, 2006 10:17 pm
- Location: Tumwater, WA
Return to SQL Prompt Previous Versions
Who is online
Users browsing this forum: No registered users and 0 guests