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

Thanks, is this about the same thing as Message #1619009?