Odd behavior when modifying select statement
frauss
Posts: 2
When attempting to add a WHERE clause to the following statement:
SELECT * FROM delta_companies ORDER BY organization_id;
autocompletion works well in terms of suggested columns till I get to this point:
SELECT * FROM delta_companies WHERE submission_id_new = 222 AND ORDER BY organization_id;
When I start typing in the 2nd column for the AND the suggestions I get are not columns in the delta_companies table but instead are table/view names.
Any idea why this would be?
Thanks,
Fred
SELECT * FROM delta_companies ORDER BY organization_id;
autocompletion works well in terms of suggested columns till I get to this point:
SELECT * FROM delta_companies WHERE submission_id_new = 222 AND ORDER BY organization_id;
When I start typing in the 2nd column for the AND the suggestions I get are not columns in the delta_companies table but instead are table/view names.
Any idea why this would be?
Thanks,
Fred
Fred Strauss
Comments
SQL Prompt will always try and get you to type fully qualified column names in a query. This is why the top suggestions are likely to be tables/views. If you select the table then you should next get prompted for the column name. Alternatively you could skip past the default suggested candidates list and go straight to the columns list by selecting the columns tab on the pop-up (ctrl+right-right).
I hope this is helpful.