corrected one inconsistency around identifier in foreach clause. one failing test.
prepare the way to have a parser that handles :: delimiter
second join statement test
join statement