Specifically, how can we express this query:
Table1 contains: id, (list of ids) Table2 contains: id, f1 Where the Table1:list is a variable length list of foreign key (id) into Table2. We would like to join every element of Table1:list with corresponding Table2:id. Ie. The final output should of the form: Table3 contains: id, (list of f1) Couldn't quite figure out how to do this - does Pig Latin support nested foreach loops? If there's a more appropriate mailing list - please re-direct, Thanks, Joydeep
