How can we help you today? How can we help you today?

JOIN condition limited to immediate previous table

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)
kevriley
0

Comments

2 comments

Sort by
  • 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.
    Anu D
    0
  • 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.
    Matthew.Wilkerson
    0

Add comment

Please sign in to leave a comment.