What are the challenges you face when working across database platforms? Take the survey

JOIN condition limited to immediate previous table

kevrileykevriley Posts: 129 Gold 1
edited October 18, 2010 5:38PM in SQL Prompt Previous Versions
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)


  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    E-mail: support@red-gate.com
  • Options
    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.
Sign In or Register to comment.