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

  • A. SELECT * FROM tblclerk OUTER JOIN tblpurchase
  • B. SELECT * FROM tblclerk C LEFT OUTER JOIN tblpurchase B ON C.sid = B.sid
  • C. SELECT * FROM tblclerk LEFT tblpurchase
  • D. None correct

Answer: Option B