Explore BrainMass

Explore BrainMass

    Query Return Results Table Values

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I attached a database. In it is a table named Table1 with these values:
    COLUMN 1 COLUMN 2
    E 5
    F 6
    G 7
    H 8
    I 9
    J 10
    K 11
    L 12
    A 1
    B 2
    C 3
    D 4

    Why wont this query return any results?

    SELECT Table1.COLUMN1, Table1.COLUMN2
    FROM Table1
    WHERE Table1.COLUMN2 = 7;

    © BrainMass Inc. brainmass.com March 4, 2021, 7:55 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/query-return-results-table-values-132327

    Attachments

    Solution Summary

    The expert examines query return result table values.

    $2.49

    ADVERTISEMENT