What is the correct syntax for SQL?

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

Answer: Option B