What code is correct in SQL for joining two tables?

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

Answer: Option B