I have an invoice table.  One field of the invoice table
is linked to a bills table.  The bills table is linked to
a suppliers table.

There are bills that match a pattern in the invoice
table and there are some invoices with the pattern with no matching bills.
There is a subset of these matching bills that match a certain supplier.

I want a query that will print all invoices that match the
pattern, and I want to print all the bills that match the
pattern from a distinct supplier.