Explore BrainMass

Explore BrainMass

    Writing correlated subqueries

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

    1. Write a correlated subquery to determine whether the data support the supposition to the following.

    Suppose that a table contains two nonkey columns; AdviserName and AdviserPhone. Further suppose that you suspect that AdviserPhone → AdviserName.

    2. Answer question 1 but use EXISTS.

    © BrainMass Inc. brainmass.com October 9, 2019, 9:47 pm ad1c9bdddf


    Solution Summary

    A correlated subquery is written to determine whether the data support required the supposition. Also an equivalent sql statement is provided using EXISTS (see attachment).