Multiple select operation

[syntencoist]

I just need a real simple command that looks up multiple tables/files using a sort/select operation (-v parameter)

the mysql equivalent would be
select a.id, b.id
from tablea a, tableb b
where a.id = b.id

[Ray_Scheel]

Presuming that you are running the -v on table.a and that tableb:index.A is based on tableb:id:

   :If:
Then: id=[tablea:field number of id]
   :If:
Then: lookup table_b = tableb k=id i=A -nx
   :If: not table_b
Then: end   '/# id not found in tableb