>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.NoField1=Client.Field1 AND Invoice.SecondCondition=True
> INNER JOIN Inventory ON Inventory.NoField2=Client.Field2 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.
If I understand your requirements, I'd
Select Invoice.NoFld1, "voi" from Invoice Where Invoice.SecondCondition=True
Union
Select Inventory.NoField2, "ven" from Inventory Where Inventory.SecondCondition=True
into cursor T_Join
and join from there (the secondary fields as a help to check until satisfied everything works, no real need...)