SQL Prompt gets confused when the a table in a schema has the same name as the schema. For example, in SQL05, create a schema named "Form". Then create tables named Form, FormAction, FormHistory, etc. SQL Prompt lets you select the schema, but then you only get column names from the Form table. The workaround is to alias the table, and then do your column and join selection on other tables. Not sure if this is fixable or not...
Add comment
Please sign in to leave a comment.