add sql to ignore
add Join support
add tests for Join