Use Queries to show records based on conditions

Follow

Comments

3 comments

  • Avatar
    Gustavo A. Valero P.

    Hi,

    I have a little problem using LABEL and ORDER clauses at the same time.

    If I write:

    SELECT A, C, D ORDER BY D       -->   the query works fine

    but with:

    SELECT A, C, D LABEL A ' Name', C 'Phone' ORDER BY D   -->   the query sends an error message!!

    Is there a little bug or I'm missing anything? 

    Thanks in advance for your help!

    Gavp

    BTW...  great web site, product and ideas, congratulations!!

  • Avatar
    Awesome Table

    Hello Gustavoavalerop,

    Actually, when you use SELECT and ORDER, ORDER must be just after SELECT. I suggest you use:

    SELECT A,C,D ORDER BY D LABEL A 'Name', C 'Phone'

    It should work with this method.

    Kind regards.

    Thomas

  • Avatar
    Gustavo A. Valero P.

    Hi Thomas,

    Yes, you are right, now my query works correctly!

    Thanks

    Gavp

Please sign in to leave a comment.