Hello,
Im running a query that relies on two sub queries. How do I display the results of the main query if one of the subqueries returns nothing?
Hello,
Im running a query that relies on two sub queries. How do I display the results of the main query if one of the subqueries returns nothing?
Usually use an outer join from the 1sr query to the 2nd query so it should show all records from 1st query and will be blank for those fields from the 2nd query if there are no matching records. If that is not what you are looking for maybe provide an example.