learned alias not working

bogieman

I just installed SQL Prompt. I am now trying to modify an existing sql view all the tables. I have the "Learn aliases when typing" and "Learn aliases when opening or pasting text" checked.

SQL Prompt will not recognize that aliases exist in the view. I have tried pulling the view directly from the database as well as a sql text file. I have even tried changing the alias and it will not pick up the table alias.

I have tried other views and they work. The only thing I can see is that the from table is a sub-select. One view has a sub-select in a join and all aliases will show in the candidate list. I have found other views where the from table is a sub-select and the aliases will not show in the candidate list.

Bart Read

Hi there,


Any chance you could post up the script please so I can try to work out what the problem is?


Thanks,
Bart