What is the correct syntax for SQL for theta join of tblseller and tblsell?

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

Answer: Option B