P
Petterq
When running a query that picks values fromm multiple tables, the query fails
if one table do not have a record that matches the selectrion criteria.
I.e. I run a query to make an order acknowledgment for a customer. The
customer can order both a service and/or and item.
If the customer orders only a service, the query fails if I do not add a
record for "no order" in the items table.
How can I make the query run when there is no value in this table?
if one table do not have a record that matches the selectrion criteria.
I.e. I run a query to make an order acknowledgment for a customer. The
customer can order both a service and/or and item.
If the customer orders only a service, the query fails if I do not add a
record for "no order" in the items table.
How can I make the query run when there is no value in this table?