What is the correct syntax for SQL for theta join of tblstudent and tblregister?

  • A. SELECT * FROM tblstudent C & tblregistering B WHERE C.cid = B.cid
  • B. SELECT * FROM tblstudent C, tblregistering B WHERE C.cid = B.cid
  • C. SELECT * FROM tblstudent C AND tblregistering B WHERE C.cid = B.cid
  • D. None correct

Answer: Option B