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

Odd behavior when modifying select statement

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
frauss
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    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.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.