What is the correct syntax for SQL for theta join of tblclerk and tblpurchase?

  • A. SELECT * FROM tblclerk C & tblselling B WHERE C.sid = B.sid
  • B. SELECT * FROM tblclerk C, tblselling B WHERE C.sid = B.sid
  • C. SELECT * FROM tblclerk C AND tblselling B WHERE C.sid = B.sid
  • D. None correct

Answer: Option B