MySQL Forums
Forum List  »  French

Update et jointure entre 2 tables
Posted by: Jean-Edouard Canton
Date: September 29, 2019 11:09AM

Bonjour à tous.

J'ai besoin de faire un update sur une table, en important 2 colonnes venant d'une autre.

J'arrive à faire "dialoguer" les 2 tables comme ca :
SET SQL_BIG_SELECTS=1;
SELECT nom, dep,
FROM stationE85
INNER JOIN fullstation ON stationE85.station = fullstation.nom AND stationE85.dep = fullstation.CP

J'ai besoin de recuperer les 2 colonnes longitude et latitude et mettre les valeurs sur la premiere table.

Je ne sais pas si je suis clair ?

merci d avance.

http://www.canton-tech.org

Options: ReplyQuote


Subject
Views
Written By
Posted
Update et jointure entre 2 tables
544
September 29, 2019 11:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.