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

No list after JOIN

Hi

I just installed SQL Prompt and while I do get a table list after a FROM I can't get the table list to popup after a JOIN. For example, typing:
select * from

I get a table list when hitting the space bar after "from", but typing:
select * from Orders o
inner join

Hitting the space bar doesn't produce the table list. If I continue typing in the query like this
select * from Orders o
inner join OrderDetails od
on o.ID = od.OrderID

I do get the field list after typing "o." and "od."

I've tried different capitalizations, different types of joins, using and not using aliases, and so far nothing will show the table list after a JOIN. I do get table lists on other keywords (update, into, from, etc) and the JOIN keyword is in the trigger word list.

Any ideas?
Thanks
Dan
djs
0

Comments

2 comments

Sort by
  • Iron Mike
    What I noticed was that after I typed JOIN, the only tables that appeared in intellisense were ones that had a Foreign Key Relationship to the prior table.

    If you don't have an FK relation between Orders and OrderDetails, create one. Then see if you get intellisense.

    Mike
    Iron Mike
    0
  • Tilman
    Hi Dan,

    thanks for posting. I get the problem, too, although sometimes it does work. I couldn't reproduce it reliably, though. We will rewrite the parser for the next version, so hopefully this issue will go away. For the moment, the only workaround I can offer is to type the table owner name followed by a dot, eg. 'dbo.' which should bring up the table list more reliably.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.