QUERY dont match VENETO

[sal21]

QUERY dont match VENETO, WHY!!!

Run query1

[HansV]

What do you mean?

S2509.png

[sal21]

What do you mean?


S2509.png

YES.
the code of this REGIONE is 05

[HansV]

The query returns REG from SAM_REGIONI:

Code: Select all

SELECT SAM_REGIONI.REG, SAM_REGIONI.REGIONE
FROM SAM_REGIONI INNER JOIN REGIONI ON SAM_REGIONI.REGIONE = REGIONI.REGIONE;

The code of VENETO in SAM_REGIONI is 0, not 5:

S2510.png

[sal21]

The query returns REG from SAM_REGIONI:

Code: Select all

SELECT SAM_REGIONI.REG, SAM_REGIONI.REGIONE
FROM SAM_REGIONI INNER JOIN REGIONI ON SAM_REGIONI.REGIONE = REGIONI.REGIONE;

The code of VENETO in SAM_REGIONI is 0, not 5:


S2510.png

OK.
But i need to update reg and reg1 in SAM_REGIONI with a mtach REGIONI<>REGIONI

[HansV]

UPDATE SAM_REGIONI INNER JOIN REGIONI ON SAM_REGIONI.REGIONE = REGIONI.REGIONE SET SAM_REGIONI.REG = [REGIONI].[REG], SAM_REGIONI.REG1 = [REGIONI].[REG1];

[HansV]

And? Does it work?

[sal21]

And? Does it work?

yes. tks