Carol, who is an SDET professional has written the following queires.
A. SELECT Id, EName, E.CompId AS E_CompId, C. CompId AS C_CompId, Model
FROM EmpTable INNER JOIN Computer C ON E.CompId = C.CompId WHERE Deptid='ETA'
B. SELECT Id, EName, E.CompId AS E_CompId, C.CompId AS C_CompId, Model
FROM EmpTable E INNER JOIN Computer C ON E.CompId = C.CompId AND Deptid = 'ETA'
Select correct answer from the following:
To get all Infosys Certified Database and SQL Professional Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee