TEIID-3102 - changed to useAnsiJoin syntax because ModeShape requires JOIN syntax

TEIID-3102 added unit test

TEIID-3102  added unit test for JOIN and JCR_ISCHILDNODE