JOIN not work

[sal21]

Possible cause this sql dont update DT:

Code: Select all

UPDATE ANA_AG INNER JOIN L0928_SI ON ANA_AG.COD_AG = L0928_SI.SPORT SET L0928_SI.DT = ANA_AG.COD_DT WHERE L0928_SI.SPORT='0100'

SPORT is text
COD_AG is text

and sure have in ana_ag correspondence COD_AG 0100>COD_DT 4587

[HansV]

Do you have an index on the join fields?

[sal21]

Do you have an index on the join fields?

Yes... on SPORT and COD_AG

[HansV]

I'm afraid I'd have to see the database...

[Rui]

I would suggest a simple similar select query, just to check if there are any records that should be updated:

Code: Select all

SELECT * FROM ANA_AG INNER JOIN L0928_SI ON ANA_AG.COD_AG = L0928_SI.SPORT  WHERE L0928_SI.SPORT='0100'