Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with SQL statement
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Help with SQL statement
Divers
Thread ID:
00174254
Message ID:
00174254
Vues:
76
I have a table with 3 fields with data as follows:
<B>CLASS            CODE         DESCRIPTION</B>
Orientation         H         Horizontal          
Orientation         V         Vertical            
Orientation         I         Island              
Orientation         S         Square              
Geography           F         Full run            
Geography           A         A/B split           
Geography           R         Regional            
Size                A         Full Page           
Size                B         1/2 Page            
Size                C         1/4 Page            
Size                D         1/8 Page            
Color               4         4 Colors            
Color               2         2 Colors            
Color               0         Black and White
Now, I need to build a table with CODE and DESCRIPTION field for each combination of 4 different classes. If my math is correct, I should have 144 records (4 Orientations X 3 Geography X 4 Sizes X 3 Colors). Both the CODE and DESCRIPTION field should contain "combined" data. An example of which would be: HFA4 (Horizontal, Full run, Full Page, 4 Colors). I'm looking for an "easy" SQL command to do this.
It's "my" world. You're just living in it.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform