I am having difficulty getting all the rows to show from the 'Customer' table, as they are not all listed in the 'SalesOrder' table I have joined. 

How do I get all the rows to show from the Customer table even if they have a 0 value? Thank you for any suggestions :)

```
SELECT Customer.CID, Customer.Name, 
COUNT (SalesOrder.CID) AS NbrOrders, 
SUM (FullPrice) AS [Total Value of Items]
FROM (Customer
  INNER JOIN SalesOrder
  ON Customer.CID=SalesOrder.CID)
GROUP BY Customer.CID, Customer.Name;

```