Skip to content

Settings and activity

3 results found

  1. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Prompt  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Jeremy Hodge supported this idea  · 
  2. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Jeremy Hodge supported this idea  · 
  3. 8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Jeremy Hodge supported this idea  · 
    An error occurred while saving the comment
    Jeremy Hodge commented  · 

    This is a must have for me as well. I am constantly writing the same join clauses. It would be great to have a mapping (similar to the custom aliases) where you can specify the most common joins. When you attempt to join the two tables, those results should be at the top of the list. Ideally, if there are several join conditions, they would all be applied as a single suggestion.

    In my situation, foreign keys typically exist and some fields are named identically, but there are so many similar column names that I usually have to scroll several pages on the suggestion list.

    Additionally, when 'use ranked suggestions' is selected, the most commonly used joins should be ranked at the top. I was expecting this behavior when ranked suggestions was implemented, but it does not appear to rank joins.