Options
JOIN Suggestions
MikeONeill
Posts: 131
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
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
Comments
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
Principal Consultant
bartread.com Ltd