$(4"$

An accounting information system stores purchase orders in a PurchaseOrder table and stores approved vendors in a Vendor table, as shown below. The database administrator enforces referential integrity between the two tables.

Vendor table

$\backslash$table$[[$Field$,$Data type$],[$VendorID$,$Integer $($primary key$)],[$VendorName$,$Varchar $(25)]]$

PurchaseOrder table

$\backslash$table$[[$Field$,$Data type$],[$PurchaseOrderNumber$,$Integer $($primary key$)],[$PurchaseOrderDate$,$Date$()],[$VendorID$,$Integer $($foreign key to vendor table$)]]$

SELECT PurchaseOrderNumber, PurchaseOrderDate, PurchaseOrder.VendorID

FROM PurchaseOrder LEFT JOIN Vendor ON PurchaseOrder.VendorID $=$ Vendor.VendorID WHERE $(($Vendor$.$VendorID$)$ Is Null$)$;

Based on the tables and the SQL statement above, which of the following statements is true?

A$.$ Return no records from either table.

B$.$ Return all purchase orders from the purchase order table.

C$.$ Return all vendors from the vendor table.

D$.$ Return all records from the purchase order and vendor tables.