I've succeed in processing a join SQL cross a JDBC data source and csv data source in Teiid Designer.
Could you please show more details?
This error external to Teiid. You need to figure out what error means by
Error Code: 1906510
in Composite Source, or eclipse.
You can also simply things by just issuing the query shown above directly against the source. It may simply turn out to be an unsupported syntax issue.