>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.

Try

select Numero from Client where exists (select 1 from Invoice 
where Invoice.Numero=Client.NoInvoice AND Invoice.SecondCondition=True)
OR exists (select 1 from Inventory 
where Inventory.Numero=Client.NoInventory AND Inventory.SecondCondition=True)

This way either of the conditions will be true.