I have 2 "order" records in a table. My query reads as follows:
select customerID, orderID, customerCompany from orders, customer where orders.customerID = customer.ID
This will display the customer ID, order ID and the friendly customer name.
One order has a customerID while the other doesn't. Only the record with the customerID shows. Can I remedy this via a query modification?