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

JOIN Suggestions

The previous versions had better support for JOIN suggestions ,

The most obvious first choice is matching same names eg a.ParameterID = b.ParameterID , followed by matching data types eg Int to Join with Int

At the moment SQL Propmt3 offers a "never ending" list that you have to dig through to get to a Match , you almost have to know what you need to join before it helps you
MikeONeill
0

Comments

1 comment

Sort by
  • Bart Read
    Hi Mike,


    If it helps you can disable everything other than foreign key based join conditions on the Candidates tab in the Options dialog. Just uncheck the two options under "Join Conditions". The first patch release also allows you to specify whether you only wish to see foreign key join conditions that use all columns in the key. We might add a few more tweaks to this behaviour as well, particularly with respect to ordering of the suggested conditions, if we have time.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.