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

JOIN Suggestions

MikeONeillMikeONeill Posts: 131
edited February 14, 2007 6:45AM in SQL Prompt Previous Versions
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

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    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
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.