Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Append from SQL cursor
I want the output from 3 SQL Selects in 1 file. What's the simplest way to do this?
Select ... into DBF [A|B|C]
then append from [A|B|C]
then delete [A|B|C]
'seems like too much overhead; especially on disk accesses.
I tried "Select * from a,b,c into cursor qcOutput", but i ended up with 27 records instead of 9. I know the extra records are partially because i have no join condition. What is the syntax to fix this?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement