Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with a union
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00666184
Message ID:
00666228
Vues:
18
This message has been marked as a message which has helped to the initial question of the thread.
Hi, Kirk!

BTW: You can prevent from using &-operator due to using name substitution (name substition is faster!):
SELECT iif(!empty(localdesc),localdesc,DESCRIPTIO),PADR(dcode,15) AS dcode1 ;
	FROM ( m.gcProcDBF ) ;
	where screenoption=[RADIOLOGY] ;
	UNION ALL ;
	SELECT procalias, PADR(dcode,15) AS dcode1 ;
	FROM ( m.gcPAlias ) ;
	ORDER BY 1 ;
	INTO ARRAY RADPROCS 
SeBaFlu
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform