Joins SQL not being generated correctly.

rbuser

When creating a dataview, joing tables generates SQL in the WHERE clause,
instead of creating join clauses. It seems like it was generating Join
statements until recently, so I suspect that there's either a setting that's
changed, or it was caused by our recent upgrade to IBExpress version 6,02.
Any thoughts?

nicocizik

Hi Brent,

Try changing the SQL Type in the Data Settings dialog to SQL2 rather than
SQL1. This should solve the issue.

--