Question: JOIN TABLES #28 Use the following query to answer the question below it: SELECT * FROM PATIENT LEFT OUTER JOIN PATIENT ON PATIENT.MOTHER_PAT_ID = PATIENT.PAT_ID

 JOIN TABLES #28 Use the following query to answer the question

JOIN TABLES #28 Use the following query to answer the question below it: SELECT * FROM PATIENT LEFT OUTER JOIN PATIENT ON PATIENT.MOTHER_PAT_ID = PATIENT.PAT_ID When you try to run the query, you get the error: "Invalid object name 'PATIENT'.". What do you need to fix in this FROM clause to resolve the error? SELECT ONE OF THE FOLLOWING (1 PT) A. Add another column to your join B. Add aliases to your two tables C. Change the columns used in your join D. Change the join type

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!