Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace record from other dbf
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00994807
Message ID:
00994928
Vues:
20
No it sould insert only the DISTINCT records from Table opened in alias № 6
SELECT 38
ZAP
alias38 = ALIAS()

SELECT 6

alias6 = ALIAS()


INSERT INTO (alias38) (scode, lcode, sec) SELECT DISTINCT scode, lcode, sec FROM (alias6) GROUP BY scode, lcode, sec

SELECT 38
GO TOP
brows
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform