In a query, I have two INNER JOIN. Either one of the two as a match to fit in the result.

For example, I may have this:

SELECT Client.Numero
 FROM Client
 INNER JOIN Invoice ON Invoice.Numero=Client.NoInvoice AND Invoice.SecondCondition=True
 INNER JOIN Inventory ON Inventory.Numero=Client.NoInventory AND Inventory.SecondCondition=True

As is, this will return no record.

If I use LEFT JOIN on both tables, this will return all the records.

I basically need a INNER JOIN on one or the other.