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

Suggested Joins not displayed ?

In SQL Prompt 2, there was a list of possible joins between tables. Is there a way of getting a list in SQL Prompt 3.

example:
select top 1 * from
[dbo].[Quotes] AS q join [dbo].[QuoteItem] AS qi on <no suggestions ???>

when I continue

select top 1 * from
[dbo].[Quotes] AS q join [dbo].[QuoteItem] AS qi on q.

I get a list of all columns instead of those specific to the alias q. Is there a way around this. ?

emails4me
emails4me
0

Comments

1 comment

Sort by
  • Tilman
    Hi,
    In SQL Prompt 2, there was a list of possible joins between tables. Is there a way of getting a list in SQL Prompt 3.

    As mentioned in the release notes, we currently only suggest join condidtions for foreign key relationships. So maybe that is the problem?
    select top 1 * from
    [dbo].[Quotes] AS q join [dbo].[QuoteItem] AS qi on q.

    I get a list of all columns instead of those specific to the alias q. Is there a way around this. ?

    That is how it should work and will work in the final release. As mentioned in the release notes this is not working in the beta, however.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.