JOIN condition limited to immediate previous table

kevriley

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)

Anu D

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.

Matthew.Wilkerson

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.