Michely

JOIN AND CONEXAO SQL

Discussion created by Michely on Sep 19, 2013
I am trying to perform a join of my table (INSC_MUNICIPAL) with a table that I access via the sql connection (REGISTRATION). But I can not run, the following error appears:

The number of matching records for the join:
- No matches found by joining [INSC_MUNICIPAL_1] from <LOTES_01> with [REGISTRATION] from <preceita.DPVIEW.%vwIMOVEL>

I checked the type and field size are matched.
Also looked manually and there is the same inscription on each table. I tested exporting the table for a sql dbf table and managed to run normally join.

This error only occurs when I'm using a table with remote connection.
Can anyone help me?

Outcomes