ensure that dialect is set properly

some nodes (join, in this case) did not have the proper
sql instance set on them.
Merge pull request #163 from tmont/dialect-fix

ensure that dialect is set properly