What code is correct in SQL for joining tblclerk and tblpurchase?

  • A. SELECT * FROM tblclerk JOIN tblpurchase
  • B. SELECT * FROM tblclerk INNER JOIN tblpurchase ON tblclerk.sid = tblpurchase.sid
  • C. SELECT * BETWEEN tblclerk AND tblpurchase ON tblclerk.sid = tblpurchase.sid
  • D. None correct

Answer: Option B