Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with SQL statement
Message
From
08/01/1999 19:19:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Help with SQL statement
Miscellaneous
Thread ID:
00174254
Message ID:
00174254
Views:
75
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.
Next
Reply
Map
View

Click here to load this message in the networking platform