Devart Forums

I've generated a support ticket but thought I'd ask here also.

I'm getting an "Unable to parse Join. Check correctness of join conditions and avoid nested joins." when I try to switch from Text entry into Query Builder.

I've copy/pasted the same SQL text in SSMS and no problems bringing up the SSMS designer. The query executes correctly in both dbForge and SSMS. It's just dbForge seems to have a SQL parsing problem.

Anyone else run into this and how did you go about trying to resolve?

Cheers, Rob.

This appears to be the issue of the server itself.

Alexa,

If that were the case then why would SSMS not have a problem with the exact same SQL Text?

I think I did find the problem, it because a Start Page new SQL query doesn't know database context (it knows Server context but not active database), so a copy and paste (even from dbForge's own SQL text generation) doesn't work.

A solution would be for dbForge to generate USE clause in all of it's SQL TEXT ... this would ensure a new Query with a cut and paste operation would get the correct database.

Cheers, Rob.

We've replied to you by e-mail on this.