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
Merge pull request #263 from vhalbert/squash

TEIID-3102 - changed to useAnsiJoin syntax