JOIN condition limited to immediate previous table

Provides intelligent code completion for SQL Server editors.

JOIN condition limited to immediate previous table

Postby kevriley » Thu Oct 14, 2010 2:43 pm

A suggestion...

when suggesting the final join conditions for the following

select *
from tableA
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: 75
Joined: Tue Apr 07, 2009 11:46 am
Location: UK

Postby Anu Deshpande » Mon Oct 18, 2010 10:07 am

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 838
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Postby Matthew.Wilkerson » Mon Oct 18, 2010 9:38 pm

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 9:17 pm
Location: Tumwater, WA

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests