HPCC-10579 Improve many lookup join implementation in roxie

Add a simple test case.

Signed-off-by: Richard Chapman <rchapman@hpccsystems.com>