Review Question 8.12: Answer question 8.10, but useEXISTS. Here is the answer to

Question

Review Question 8.12: Answer question 8.10, but useEXISTS. Here is the answer to question to 8.10: ->SELECT A1.AdvisorName, A1.AdvisorPhone     FROM ADVISOR A1     WHERE A1.AdvisorName IN      (SELECT A2.AdvisorName         FROM ADVISOR A2
        WHERE A1.AdvisorName =A2.AdvisorName           AND A1.AdvisorPhone <> A2.AdvisorPhone); Review Question 8.12: Answer question 8.10, but useEXISTS. Here is the answer to question to 8.10: ->SELECT A1.AdvisorName, A1.AdvisorPhone     FROM ADVISOR A1     WHERE A1.AdvisorName IN      (SELECT A2.AdvisorName         FROM ADVISOR A2
        WHERE A1.AdvisorName =A2.AdvisorName           AND A1.AdvisorPhone <> A2.AdvisorPhone); ->SELECT A1.AdvisorName, A1.AdvisorPhone     FROM ADVISOR A1     WHERE A1.AdvisorName IN     WHERE A1.AdvisorName IN      (SELECT A2.AdvisorName         FROM ADVISOR A2
        WHERE A1.AdvisorName =A2.AdvisorName           AND A1.AdvisorPhone <> A2.AdvisorPhone);

Explanation / Answer

Dear..... SELECT A1.AdvisorName,A1.AdvisorPhone      FROMADVISOR A1         WHERE EXISTS           (SELECT *FROM ADVISORA2               WHERE A1.AdvisorName =A2.AdvisorName                     AND A1.AdvisorPhone <>A2.AdvisorPhone); Hope this will helpyou... Hope this will helpyou...

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---