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

  • A. SELECT * FROM tblstudent JOIN tblregister
  • B. SELECT * FROM tblstudent INNER JOIN tblregister ON tblstudent.cid = tblregister.cid
  • C. SELECT * BETWEEN tblstudent AND tblregister ON tblstudent.cid = tblregister.cid
  • D. None correct

Answer: Option B