I have a query that I am pulling data in from four different tables.
In the first screen shot that I have included, you only see three of the tables.
The tables are pulling all my open purchase orders that we have in our system.
Some of these purchase orders are attached to customer, so are just a stock purchase order.
I am trying to create a list of all the purchase orders that are open and would like them to display on the same list, whether or not the purchase order is designated for a customer or not.
The customer data can be joined to this statement by pulling in the fourth table.
When I pull the fourth table in and select the DEL_DOC_NUM field, the statement does not return any of the stock purchase orders.
How do I use the NVL command so that if there isn't a DEL_DOC_NUM assigned to the purchase order, the purchase order will still show on the list.