JOIN condition limited to immediate previous table

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

JOIN condition limited to immediate previous table

Postby kevriley » Thu Oct 14, 2010 3: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: 70
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby Anu Deshpande » Mon Oct 18, 2010 11: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: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby Matthew.Wilkerson » Mon Oct 18, 2010 10: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 10:17 pm
Location: Tumwater, WA

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest