>select Client.Numero from Client join Invoice ON Invoice.Numero=Client.NoInvoice AND Invoice.SecondCondition=True >union >select Client.Numero from Client join Inventory ON Inventory.Numero=Client.NoInventory AND Inventory.SecondCondition=True > >Yes, this would work. But, as I need some fields from the other two tables, I need to keep the LEFT JOIN.