What code is correct in SQL language joining tblstudent and tblregister?

  • A. SELECT * FROM tblstudent OUTER JOIN tblregister
  • B. SELECT * FROM tblstudent C LEFT OUTER JOIN tblregister B ON C.cid = B.cid
  • C. SELECT * FROM tblstudent LEFT tblregister
  • D. None correct

Answer: Option B