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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
