If You have
A, a, Sold
B, Sold, b
If You select A, You exclude B.
However ,You can add to script
If(Status='Sold' or Inventory='Sold',1) as Flag;
Load * from .......; // or SQL Select * from ...;
Then in Your Button -> Select -> Action -> Select in Field Flag -> 1.
Also You can use expression like
in your objects.
Well the simplest and most straightforward approach I think might be to have a small two column table generated like this in your load script:
(Status = 'Sold') AS DefinitelySold
(Inventory = 'Sold') AS DefinitelySold
If the two fields are in the same table you can simplify it like this:
(Status = 'Sold' Or Inventory = 'Sold') AS DefinitelySold
In you application you can have the field DefinitelySold in a list box and that will act as your button.