FROM CLAUSE

Common Use Cases
1. Due to the order of execution of query clauses, the SELECT statement (i.e., the subquery) must first be processed for its result set or output to be referenced and/or filterable. For example, window/analytic functions, such as ROW_NUMBER, RANK, and DENSE_RANK are commonly used to tag rows with integer values associated with a user-defined ranking system. Because the corresponding attribute is derived in the SELECT clause, a user is unable to reference the derived attribute in the WHERE clause of the same SELECT statement. Thus, a subquery is required.

2. There is a need to include data at multiple levels of detail within a single result set. For example, a task may require a value within each row of a table to be compared to the result of some aggregate (e.g., average, sum, min, etc.) function computed across those rows belonging to the same group.

Example Data
The schemas, corresponding tables, and data used in the example problems can be found at livesql.oracle.com. To more easily follow the examples covered on this page, consider first reading the table descriptions below and reviewing each table’s contents. To review the data maintained in each table, click on the icon next to the table name. To hide the data, click the icon again.

oe.order_items
Contains information related to each item within a specific order. There is one row for each item within each order. For example, if a specific order has five items, then those five items will be represented by and captured within five individual rows.

order_id	line_item_id	product_id	unit_price	quantity
2354	1	3106	48	61
2354	2	3114	96.8	43
2354	3	3123	79	47
2354	4	3129	41	47
2354	5	3139	21	48
2354	6	3143	16	53
2354	7	3150	17	58
2354	8	3163	30	61
2354	9	3165	37	64
2354	10	3167	51	68
2354	11	3170	145.2	70
2354	12	3176	113.3	72
2354	13	3182	61	77
2355	1	2289	46	200
2355	2	2308	57	185
2355	3	2311	86.9	188
2355	4	2322	19	188
2355	5	2323	17	190
2355	6	2326	1.1	192
2355	7	2330	1.1	197
2355	8	2339	25	199
2355	9	2359	226.6	204
2356	1	2264	199.1	38
2356	2	2274	148.5	34
2356	3	2293	98	40
2356	4	2299	72	44
2356	5	2308	58	47
2356	6	2311	95	51
2356	7	2316	22	55
2356	8	2323	18	55
2357	1	2211	3.3	140
2357	2	2245	462	26
2357	3	2252	788.7	26
2357	4	2257	371.8	29
2357	5	2262	95	29
2357	6	2268	75	32
2357	7	2276	236.5	38
2357	8	2289	48	41
2358	1	1781	226.6	9
2358	2	1782	125	4
2358	3	1797	316.8	12
2358	4	1803	55	13
2358	5	1808	55	14
2359	1	2337	270.6	1
2359	2	2359	249	1
2359	3	2370	91	17
2359	4	2373	6	17
2359	5	2377	96	17
2359	6	2380	5.5	17
2359	7	2381	97	17
2360	1	2058	23	29
2360	2	2093	7.7	42
2361	1	2289	46	180
2361	2	2299	76	180
2361	3	2308	53	182
2361	4	2311	86.9	185
2361	5	2316	22	187
2361	6	2326	1.1	194
2361	7	2334	3.3	198
2361	8	2359	248	208
2361	9	2365	76	209
2362	1	2289	48	200
2362	2	2299	76	160
2362	3	2311	93	164
2362	4	2316	22	168
2362	5	2326	1.1	173
2362	6	2334	3.3	177
2362	7	2339	25	179
2362	8	2359	248	189
2363	1	2264	199.1	9
2363	2	2272	129	7
2363	3	2299	74	25
2363	4	2308	57	26
2363	5	2311	86.9	29
2363	6	2319	24	31
2363	7	2323	18	34
2363	8	2326	1.1	37
2363	9	2334	3.3	42
2364	1	1910	14	6
2364	2	1948	470.8	20
2365	1	2289	48	92
2365	2	2293	99	28
2365	3	2302	133.1	29
2365	4	2308	56	29
2365	5	2311	95	29
2365	6	2316	22	34
2365	7	2319	24	38
2365	8	2322	19	43
2365	9	2326	1.1	44
2365	10	2335	97	45
2365	11	2339	25	50
2365	12	2340	72	54
2366	1	2359	226.6	8
2366	2	2373	6	7
2366	3	2382	804.1	10
2366	4	2394	116.6	11
2366	5	2395	120	12
2366	6	2400	418	16
2366	7	2406	195.8	20
2366	8	2409	194.7	22
2366	9	2415	339.9	24
2366	10	2419	69	24
2367	1	2289	48	99
2367	2	2302	147	32
2367	3	2308	54	39
2367	4	2322	22	45
2367	5	2326	1.1	48
2367	6	2330	1.1	52
2367	7	2335	91.3	54
2367	8	2350	2341.9	54
2368	1	3106	48	150
2368	2	3110	42	60
2368	3	3117	38	62
2368	4	3123	81	70
2368	5	3127	496	70
2368	6	3129	42	72
2368	7	3143	16	75
2368	8	3155	45	75
2369	1	3150	18	3
2369	2	3155	43	1
2369	3	3163	32	5
2369	4	3165	34	10
2369	5	3170	145.2	24
2369	6	3176	113.3	24
2369	7	3187	2.2	24
2369	8	3193	2.2	28
2369	9	3204	123	34
2370	1	1910	14	9
2371	1	2274	157	6
2371	2	2293	96	8
2371	3	2299	73	15
2371	4	2316	21	21
2371	5	2323	17	24
2371	6	2334	3.3	26
2371	7	2339	25	29
2371	8	2350	2341.9	32
2372	1	3106	48	6
2372	2	3108	74	2
2372	3	3110	42	7
2372	4	3123	81	10
2372	5	3127	496	13
2372	6	3134	17	17
2372	7	3143	15	21
2372	8	3163	30	30
2372	9	3167	54	32
2372	10	3170	145.2	36
2373	1	1820	49	8
2373	2	1825	24	1
2374	1	2422	150	10
2374	2	2423	78	6
2374	3	2449	78	15
2374	4	2467	79	21
2375	1	3106	42	140
2375	2	3112	71	84
2375	3	3117	38	85
2375	4	3127	488.4	86
2375	5	3133	45	88
2375	6	3134	17	90
2375	7	3143	15	93
2375	8	3150	17	93
2375	9	3155	45	98
2375	10	3163	30	99
2375	11	3165	36	103
2375	12	3171	132	107
2375	13	3176	120	109
2376	1	2270	60	14
2376	2	2276	236.5	4
2376	3	2293	99	13
2376	4	2299	73	17
2376	5	2302	133.1	21
2376	6	2311	95	25
2376	7	2316	21	27
2376	8	2319	25	32
2376	9	2326	1.1	33
2376	10	2334	3.3	36
2377	1	2289	42	130
2377	2	2302	147	119
2377	3	2311	95	121
2377	4	2319	25	131
2377	5	2326	1.1	132
2377	6	2330	1.1	136
2378	1	2403	113.3	20
2378	2	2412	95	2
2378	3	2414	438.9	7
2378	4	2417	27	11
2378	5	2423	79	11
2378	6	2424	217.8	15
2378	7	2457	4.4	25
2378	8	2459	624.8	25
2379	1	3106	42	92
2379	2	3114	98	14
2379	3	3127	488.4	23
2379	4	3139	21	34
2379	5	3140	19	35
2380	1	3106	42	26
2380	2	3108	75	18
2380	3	3117	38	23
2380	4	3127	488.4	24
2380	5	3133	46	28
2380	6	3140	20	30
2380	7	3143	15	31
2380	8	3150	17	33
2380	9	3155	45	33
2380	10	3163	32	36
2380	11	3167	52	37
2380	12	3176	113.3	40
2380	13	3187	2.2	40
2381	1	3117	38	110
2381	2	3124	77	44
2381	3	3133	44	44
2381	4	3139	20	45
2381	5	3143	15	48
2381	6	3163	35	55
2381	7	3176	113.3	62
2381	8	3183	47	63
2382	1	3106	42	160
2382	2	3110	43	64
2382	3	3114	100	65
2382	4	3117	35	66
2382	5	3123	79	71
2382	6	3127	496	71
2382	7	3129	42	76
2382	8	3139	21	79
2382	9	3143	15	82
2382	10	3163	29	89
2382	11	3165	37	92
2383	1	2409	194.7	37
2383	2	2418	56	45
2383	3	2422	146	46
2383	4	2430	174	50
2383	5	2439	115.5	54
2383	6	2457	4.4	62
2383	7	2462	75	63
2384	1	2289	43	95
2384	2	2299	71	48
2384	3	2316	21	58
2384	4	2322	22	59
2384	5	2330	1.1	61
2384	6	2359	249	77
2385	1	2289	43	200
2385	2	2302	133.1	87
2385	3	2311	86.9	96
2385	4	2319	25	97
2385	5	2335	91.3	106
2385	6	2350	2341.9	109
2386	1	2330	1.1	7
2386	2	2334	3.3	5
2386	3	2340	71	14
2386	4	2365	77	27
2386	5	2370	90	28
2386	6	2375	73	32
2386	7	2378	271.7	33
2386	8	2394	116.6	36
2387	1	2211	3.3	52
2387	2	2243	332.2	20
2387	3	2245	462	22
2387	4	2252	788.7	27
2387	5	2253	354.2	32
2387	6	2268	75	42
2388	1	2289	43	150
2388	2	2293	94	90
2388	3	2308	56	96
2388	4	2330	1.1	105
2388	5	2350	2341.9	112
2389	1	3106	43	180
2389	2	3112	73	18
2389	3	3123	80	21
2389	4	3129	46	22
2389	5	3143	15	30
2389	6	3155	46	33
2389	7	3165	34	43
2389	8	3167	52	47
2390	1	1910	14	4
2390	2	1912	14	2
2390	3	1948	470.8	16
2391	1	1787	101	5
2391	2	1791	262.9	3
2391	3	1797	348	7
2391	4	1799	961.4	10
2391	5	1808	55	15
2391	6	1820	52	18
2391	7	1822	1433.3	23
2392	1	3106	43	63
2392	2	3112	73	57
2392	3	3117	38	58
2392	4	3124	77	63
2392	5	3133	45	66
2392	6	3139	21	68
2392	7	3150	18	72
2392	8	3155	49	77
2392	9	3165	40	81
2393	1	3051	12	10
2393	2	3060	295	2
2393	3	3064	1017	5
2393	4	3069	385	8
2393	5	3077	260.7	8
2393	6	3082	78	10
2393	7	3086	211	13
2393	8	3087	108.9	14
2393	9	3091	278	19
2393	10	3099	3.3	19
2393	11	3108	69.3	30
2394	1	3117	41	90
2394	2	3123	77	36
2394	3	3124	82	39
2394	4	3129	46	41
2394	5	3133	46	45
2394	6	3134	18	45
2394	7	3140	19	48
2394	8	3155	49	61
2394	9	3167	52	68
2395	1	2211	3.3	110
2395	2	2243	332.2	27
2395	3	2252	788.7	30
2395	4	2255	690.8	34
2395	5	2264	199.1	34
2395	6	2268	71	37
2395	7	2270	64	41
2396	1	3106	44	150
2396	2	3108	76	75
2396	3	3110	44	79
2396	4	3114	100	83
2396	5	3140	19	93
2396	6	3150	17	93
2396	7	3155	47	98
2396	8	3163	29	100
2397	1	2976	52	2
2397	2	2986	120	8
2397	3	2999	880	16
2397	4	3000	1696.2	16
2398	1	2471	482.9	5
2398	2	2537	193.6	23
2398	3	2594	9	27
2399	1	2289	44	120
2399	2	2293	94	12
2399	3	2299	76	15
2399	4	2302	149	17
2399	5	2308	56	17
2399	6	2311	86.9	20
2399	7	2316	22	24
2399	8	2326	1.1	27
2399	9	2330	1.1	28
2399	10	2335	100	33
2399	11	2359	226.6	38
2400	1	2976	52	4
2400	2	2982	41	1
2400	3	2986	123	4
2400	4	2999	880	16
2400	5	3003	2866.6	19
2401	1	2492	41	4
2401	2	2496	268.4	3
2402	1	2536	75	8
2403	1	2522	44	5
2404	1	2721	85	6
2404	2	2808	0	37
2405	1	2638	137	9
2406	1	2721	85	5
2406	2	2725	3.3	4
2406	3	2761	26	19
2406	4	2782	62	31
2407	1	2721	85	5
2407	2	2752	86	18
2407	3	2761	26	21
2408	1	2751	61	3
2408	2	2761	26	1
2408	3	2783	10	10
2409	1	2810	6	8
2410	1	2976	46	10
2410	2	2982	40	5
2410	3	2986	120	6
2410	4	2995	68	8
2410	5	3003	2866.6	15
2410	6	3051	12	21
2411	1	3082	81	2
2411	2	3086	208	2
2411	3	3097	2.2	6
2411	4	3099	3.3	7
2411	5	3101	73	8
2411	6	3106	45	11
2411	7	3112	72	17
2411	8	3123	75	17
2411	9	3124	84	17
2411	10	3127	488.4	18
2411	11	3133	43	23
2411	12	3143	15	24
2412	1	3106	46	170
2412	2	3114	98	68
2412	3	3123	71.5	68
2412	4	3127	492	72
2412	5	3134	18	75
2412	6	3139	20	79
2412	7	3143	16	80
2412	8	3163	30	92
2412	9	3167	54	94
2413	1	3108	77	200
2413	2	3112	75	40
2413	3	3117	35	44
2413	4	3127	492	44
2413	5	3129	46	45
2413	6	3155	47	62
2413	7	3163	30	66
2414	1	3208	1.1	8
2414	2	3216	30	7
2414	3	3220	41	9
2414	4	3234	39	11
2414	5	3246	212.3	18
2414	6	3253	206.8	23
2414	7	3260	50	24
2415	1	2751	62	5
2416	1	2870	4.4	10
2416	2	2878	340	1
2417	1	2870	4.4	9
2417	2	2976	51	37
2418	1	3082	75	15
2418	2	3090	187	12
2418	3	3097	2.2	13
2418	4	3110	45	20
2418	5	3140	20	31
2418	6	3150	17	37
2419	1	3106	46	150
2419	2	3114	99	45
2419	3	3123	71.5	48
2419	4	3129	43	57
2419	5	3133	45	61
2419	6	3150	17	69
2419	7	3155	47	72
2419	8	3165	35	76
2419	9	3167	54	81
2420	1	3106	46	110
2420	2	3110	46	11
2420	3	3114	101	15
2420	4	3123	79	20
2420	5	3127	496	22
2420	6	3133	48	29
2420	7	3140	19	34
2420	8	3143	15	39
2420	9	3163	30	45
2420	10	3171	132	47
2421	1	3106	46	160
2421	2	3108	78	160
2421	3	3112	72	164
2421	4	3117	41	165
2421	5	3123	80	168
2421	6	3129	43	172
2421	7	3143	15	176
2421	8	3150	17	176
2421	9	3155	43	185
2422	1	3106	46	18
2422	2	3117	41	5
2422	3	3123	71.5	5
2422	4	3127	496	9
2422	5	3133	46	11
2422	6	3150	17	25
2422	7	3155	43	29
2422	8	3163	30	35
2422	9	3167	54	39
2423	1	3220	39	8
2423	2	3224	32	3
2423	3	3245	214.5	13
2423	4	3246	212.3	14
2423	5	3251	26	16
2423	6	3258	78	21
2423	7	3290	65	33
2424	1	3350	693	11
2424	2	3354	541	9
2424	3	3359	111	12
2425	1	3501	492.8	3
2425	2	3511	9	2
2425	3	3515	1.1	4
2426	1	3193	2.2	6
2426	2	3216	30	11
2426	3	3234	34	18
2426	4	3248	212.3	26
2426	5	3252	25	29
2427	1	2430	173	12
2427	2	2439	121	1
2427	3	2457	4.4	6
2427	4	2464	66	6
2427	5	2470	76	6
2427	6	2496	268.4	19
2427	7	2522	40	22
2428	1	3106	42	7
2428	2	3108	76	1
2428	3	3114	101	5
2428	4	3117	41	6
2428	5	3123	80	8
2428	6	3127	498	12
2428	7	3133	48	12
2428	8	3143	16	13
2428	9	3150	17	16
2428	10	3170	145.2	24
2428	11	3173	86	28
2429	1	3106	42	200
2429	2	3108	76	40
2429	3	3110	45	43
2429	4	3123	79	46
2429	5	3127	497	49
2429	6	3133	46	52
2429	7	3139	21	54
2429	8	3150	17	55
2429	9	3163	30	63
2429	10	3165	36	67
2430	1	3350	693	6
2430	2	3353	454.3	5
2430	3	3359	111	10
2430	4	3362	94	10
2430	5	3501	492.8	43
2431	1	3097	2.2	3
2431	2	3106	48	1
2431	3	3114	101	3
2431	4	3117	41	7
2431	5	3127	498	9
2431	6	3129	44	11
2432	1	2976	49	3
2432	2	2982	43	2
2432	3	2986	122	5
2432	4	2999	880	11
2433	1	1910	13	6
2434	1	2211	3.3	81
2434	2	2236	949.3	84
2434	3	2245	462	86
2434	4	2252	788.7	87
2434	5	2254	408.1	92
2434	6	2257	371.8	94
2434	7	2268	75	104
2435	1	2289	48	35
2435	2	2299	75	4
2435	3	2311	86.9	8
2435	4	2316	21	10
2435	5	2323	18	12
2435	6	2334	3.3	14
2435	7	2339	25	19
2435	8	2350	2341.9	24
2435	9	2365	75	33
2436	1	3208	1.1	8
2436	2	3209	13	2
2436	3	3216	30	3
2436	4	3224	32	6
2436	5	3245	214.5	16
2436	6	3250	27	18
2436	7	3256	36	18
2436	8	3290	63	24
2437	1	2423	83	8
2437	2	2430	157.3	4
2437	3	2457	4.4	17
2437	4	2462	76	19
2437	5	2464	64	21
2437	6	2496	268.4	35
2438	1	2995	69	3
2438	2	3000	1748	3
2439	1	1797	316.8	9
2439	2	1806	45	4
2439	3	1820	54	9
2439	4	1822	1433.3	13
2440	1	2289	48	19
2440	2	2293	98	2
2440	3	2302	150	2
2440	4	2311	86.9	7
2440	5	2322	23	10
2440	6	2330	1.1	13
2440	7	2334	3.3	15
2440	8	2337	270.6	19
2440	9	2339	25	23
2440	10	2350	2341.9	24
2440	11	2359	226.6	28
2441	1	2536	80	9
2441	2	2537	193.6	7
2442	1	2402	127	26
2442	2	2410	350.9	21
2442	3	2418	60	23
2442	4	2422	144	25
2442	5	2430	173	28
2442	6	2439	115.5	30
2442	7	2459	624.8	40
2442	8	2467	80	44
2443	1	3106	44	3
2443	2	3114	101	2
2443	3	3124	82	6
2443	4	3139	20	12
2443	5	3143	15	17
2443	6	3150	18	17
2443	7	3155	43	21
2443	8	3165	36	31
2444	1	3117	36	110
2444	2	3127	488.4	88
2444	3	3133	43	90
2444	4	3139	21	93
2444	5	3140	19	95
2444	6	3143	15	97
2444	7	3150	17	100
2444	8	3155	43	104
2444	9	3165	37	112
2444	10	3172	37	112
2444	11	3182	63	115
2445	1	2270	66	5
2445	2	2278	49	3
2445	3	2293	97	11
2445	4	2299	72	14
2445	5	2311	95	24
2445	6	2319	25	27
2445	7	2326	1.1	28
2446	1	2289	48	47
2446	2	2326	1.1	34
2446	3	2330	1.1	36
2446	4	2337	270.6	37
2446	5	2350	2341.9	39
2447	1	2264	199.1	29
2447	2	2266	297	23
2447	3	2272	121	24
2447	4	2278	50	25
2447	5	2293	97	34
2447	6	2299	76	35
2447	7	2302	133.1	37
2447	8	2308	54	40
2447	9	2311	93	44
2448	1	3106	44	3
2448	2	3114	99	0
2448	3	3133	42	11
2448	4	3134	17	14
2448	5	3139	20	15
2448	6	3143	16	16
2449	1	2522	43	2
2450	1	3191	1.1	4
2450	2	3193	2.2	3
2450	3	3197	44	5
2450	4	3216	29	11
2450	5	3220	41	14
2450	6	3224	32	16
2451	1	1910	13	9
2451	2	1948	470.8	22
2452	1	3117	38	140
2452	2	3139	20	10
2452	3	3143	15	12
2452	4	3150	17	13
2452	5	3155	44	13
2452	6	3165	34	18
2452	7	3170	145.2	20
2452	8	3172	37	20
2452	9	3173	80	23
2453	1	2492	43	3
2454	1	2289	43	120
2454	2	2293	99	0
2454	3	2299	71	3
2454	4	2308	55	12
2454	5	2316	21	13
2454	6	2323	18	16
2454	7	2334	3.3	18
2455	1	2471	482.9	3
2455	2	2496	268.4	32
2455	3	2536	75	54
2456	1	2522	40	5
2456	2	2537	193.6	19
2457	1	3108	72	36
2457	2	3123	79	14
2457	3	3127	488.4	17
2457	4	3150	17	27
2457	5	3155	44	32
2457	6	3170	145.2	42
2457	7	3172	36	45
2458	1	3117	38	140
2458	2	3123	79	112
2458	3	3127	488.4	114
2458	4	3134	17	115
2458	5	3143	15	129
2458	6	3163	32	142

oe.product_information
Contains information related to each product. There is one row per product.

product_id	product_name	product_description	category_id	weight_class	warranty_period	supplier_id	product_status	list_price	min_price	catalog_url
1797	Inkjet C/8/HQ	Inkjet printer, color, 8 pages per minute, high resolution (photo quality). Memory: 16MB. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A4, US Letter, envelopes. Interface: Centronics parallel, IEEE 1284 compliant.	12	3	2	102094	orderable	349	288	http://www.supp-102094.com/cat/hw/p1797.html
2459	LaserPro 1200/8/BW	Professional black and white laserprinter, resolution 1200 dpi, 8 pages per second. Dimensions (HxWxD): 22.37 x 19.86 x 21.92 inch. Software: Enhanced driver support for SPNIX v4.0; MS-DOS Built-in printer drivers: ZoomSmart scaling technology, billboard, handout, mirror, watermark, print preview, quick sets, emulate laserprinter margins.	12	5	3	102099	under development	699	568	http://www.supp-102099.com/cat/hw/p2459.html
3127	LaserPro 600/6/BW	Standard black and white laserprinter, resolution 600 dpi, 6 pages per second. Interface: Centronics parallel, IEEE 1284 compliant. Memory: 8MB 96KB receiver buffer. MS-DOS ToolBox utilities for SPNIX AutoCAM v.17 compatible driver.	12	4	3	102087	orderable	498	444	http://www.supp-102087.com/cat/hw/p3127.html
2254	HD 10GB /I	10GB capacity hard disk drive (internal). These drives are intended for use in today’s demanding, data-critical enterprise environments and are ideal for use in RAID applications. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.	13	2	2	102071	obsolete	453	371	http://www.supp-102071.com/cat/hw/p2254.html
3353	HD 10GB /R	10GB Removable hard disk drive for 10GB Removable HD drive. Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 160MB/s.	13	1	3	102071	obsolete	489	413	http://www.supp-102071.com/cat/hw/p3353.html
3069	HD 10GB /S	10GB hard disk drive for Standard Mount. Backward compatible with Supra5 systems, users are free to deploy and re-deploy these drives to quickly deliver increased storage capacity. Supra drives eliminate the risk of firmware incompatibility.	13	1	2	102051	obsolete	436	350	http://www.supp-102051.com/cat/hw/p3069.html
2253	HD 10GB @5400 /SE	10GB capacity hard disk drive (external) SCSI interface, 5400 RPM. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system. Supra drives eliminate the risk of firmware incompatibility.	13	2	3	102069	obsolete	399	322	http://www.supp-102069.com/cat/hw/p2253.html
3354	HD 12GB /I	12GB capacity harddisk drive (internal). Supra drives eliminate the risk of firmware incompatibility. Backward compatibility: You can mix or match Supra2 and Supra3 devices for optimized solutions and future growth.	13	2	2	102066	orderable	543	478	http://www.supp-102066.com/cat/hw/p3354.html
3072	HD 12GB /N	12GB hard disk drive for Narrow Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.	13	1	3	102061	orderable	567	507	http://www.supp-102061.com/cat/hw/p3072.html
3334	HD 12GB /R	12GB Removable hard disk drive. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity. Supra7 Universal disk drives are the second generation of high performance hot plug drives sharing compatibility across corporate servers and external storage enclosures.	13	2	3	102090	orderable	612	512	http://www.supp-102090.com/cat/hw/p3334.html
3071	HD 12GB /S	12GB hard disk drive for Standard Mount. Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Our hot pluggable hard disk drives are required to meet our rigorous standards for reliability and performance.	13	1	3	102071	orderable	633	553	http://www.supp-102071.com/cat/hw/p3071.html
2255	HD 12GB @7200 /SE	12GB capacity hard disk drive (external) SCSI, 7200 RPM. These drives are intended for use in today’s demanding, data-critical enterprise environments and can be used in RAID applications. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.	13	2	2	102057	orderable	775	628	http://www.supp-102057.com/cat/hw/p2255.html
1743	HD 18.2GB @10000 /E	External hard drive disk – 18.2 GB, rated up to 10,000 RPM. These drives are intended for use in today’s demanding, data-critical enterprise environments and are ideal for use in RAID applications.	13	3	3	102078	planned	800	661	http://www.supp-102078.com/cat/hw/p1743.html
2382	HD 18.2GB@10000 /I	18.2 GB SCSI hard disk @ 10000 RPM (internal). Supra7 Universal disk drives provide an unequaled level of investment protection and simplification for customers by enabling drive compatibility across many enterprise platforms.	13	3	3	102050	under development	850	731	http://www.supp-102050.com/cat/hw/p2382.html
3399	HD 18GB /SE	18GB SCSI external hard disk drive. Supra5 Universal hard disk drives provide the ability to hot plug between various servers, RAID arrays, and external storage shelves.	13	3	2	102083	under development	815	706	http://www.supp-999999.com/cat/hw/p3333.html
3073	HD 6GB /I	6GB capacity hard disk drive (internal). Supra drives eliminate the risk of firmware incompatibility.	13	2	5	102072	obsolete	224	197	http://www.supp-102083.com/cat/hw/p3073.html
1768	HD 8.2GB @5400	Hard drive disk – 8.2 GB, rated up to 5,400 RPM. Supra drives eliminate the risk of firmware incompatibility. Standard serial RS-232 interface.	13	2	2	102093	orderable	345	306	http://www.supp-102093.com/cat/hw/p1768.html
2410	HD 8.4GB @5400	8.4 GB hard disk @ 5400 RPM. Reduced cost of ownership: Drives can be utilized across enterprise platforms. This hot pluggable hard disk drive is required to meet your rigorous standards for reliability and performance.	13	2	3	102061	orderable	357	319	http://www.supp-102061.com/cat/hw/p2410.html
2257	HD 8GB /I	8GB capacity hard disk drive (internal). Supra9 hot pluggable hard disk drives provide the ability to install or remove drives on-line. Backward compatibility: You can mix Supra2 and Supra3 devices for optimized solutions and future growth.	13	1	3	102061	orderable	399	338	http://www.supp-102061.com/cat/hw/p2257.html
3400	HD 8GB /SE	8GB capacity SCSI hard disk drive (external). Supra7 disk drives provide the latest technology to improve enterprise performance, increasing the maximum data transfer rate up to 255MB/s.	13	2	3	102063	orderable	389	337	http://www.supp-102063.com/cat/hw/p3400.html
3355	HD 8GB /SI	8GB SCSI hard disk drive, internal. With compatibility across many enterprise platforms, you are free to deploy and re-deploy this drive to quickly deliver increased storage capacity.	13	1	2	102050	orderable	–	–	http://www.supp-102050.com/cat/hw/p3355.html
1772	HD 9.1GB @10000	Hard disk drive – 9.1 GB, rated up to 10,000 RPM. These drives are intended for use in data-critical enterprise environments. Ease of doing business: you can easily select the drives you need regardless of the application in which they will be deployed.	13	3	5	102070	orderable	456	393	http://www.supp-102070.com/cat/hw/p1772.html
2243	Monitor 17/HR/F	Monitor 17 inch (16 viewable) high resolution, flat screen. High density photon gun with Enhanced Elliptical Correction System for more consistent, accurate focus across the screen, even in the corners.	11	4	-6	102060	orderable	350	302	http://www.supp-102060.com/cat/hw/p2243.html
3057	Monitor 17/SD	CRT Monitor 17 inch (16 viewable) short depth. Delivers outstanding image clarity and precision. Gives professional color, technical engineering, and visualization/animation users the color fidelity they demand, plus a large desktop for enhanced productivity.	11	4	-6	102055	orderable	369	320	http://www.supp-102055.com/cat/hw/p3057.html
3061	Monitor 19/SD	CRT Monitor 19 inch (18 viewable) short depth. High-contrast black screen coating: produces superior contrast and grayscale performance. The newly designed, amplified professional speakers with dynamic bass response bring all of your multimedia audio experiences to life with crisp, true-to-life sound and rich, deep bass tones. Plus, color-coded cables, simple plug-and-play setup and digital on-screen controls mean you are ready to set your sights on outrageous multimedia and the incredible Internet in just minutes.	11	5	-9	102094	orderable	499	437	http://www.supp-102094.com/cat/hw/p3061.html
2245	Monitor 19/SD/M	Monitor 19 (18 Viewable) short depth, Monochrome. Outstanding image performance in a compact design. A simple, on-screen dislay menu helps you easily adjust screen dimensions, colors and image attributes. Just plug your monitor into your PC and you are ready to go.	11	5	-9	102053	orderable	512	420	http://www.supp-102053.com/cat/hw/p2245.html
3065	Monitor 21/D	CRT Monitor 21 inch (20 viewable). Digital OptiScan technology: supports resolutions up to 1600 x 1200 at 75Hz. Dimensions (HxWxD): 8.3 x 18.5 x 15 inch. The detachable or attachable monitor-powered Platinum Series speakers offer crisp sound and the convenience of a digital audio player jack. Just plug in your digital audio player and listen to tunes without powering up your PC.	11	5	1	102051	orderable	999	875	http://www.supp-102051.com/cat/hw/p3065.html
3331	Monitor 21/HR	21 inch monitor (20 inch viewable) high resolution. This monitor is ideal for business, desktop publishing, and graphics-intensive applications. Enjoy the productivity that a large monitor can bring via more workspace for running applications.	11	5	1	102083	orderable	879	785	http://www.supp-102083.com/cat/hw/p3331.html
2252	Monitor 21/HR/M	Monitor 21 inch (20 viewable) high resolution, monochrome. Unit size: 35.6 x 29.6 x 33.3 cm (14.6 kg) Package: 40.53 x 31.24 x 35.39 cm (16.5 kg). Horizontal frequency 31.5 – 54 kHz, Vertical frequency 50 – 120 Hz. Universal power supply 90 – 132 V, 50 – 60 Hz.	11	5	-5	102079	obsolete	889	717	http://www.supp-102079.com/cat/hw/p2252.html
3064	Monitor 21/SD	Monitor 21 inch (20 viewable) short depth. Features include a 0.25-0.28 Aperture Grille Pitch, resolution support up to 1920 x 1200 at 76Hz, on-screen displays, and a conductive anti-reflective film coating.	11	5	-5	102096	planned	1023	909	http://www.supp-102096.com/cat/hw/p3064.html
3155	Monitor Hinge – HD	Monitor Hinge, heavy duty, maximum monitor weight 30 kg	11	4	10	102092	orderable	49	42	http://www.supp-102092.com/cat/hw/p3155.html
3234	Monitor Hinge – STD	Standard Monitor Hinge, maximum monitor weight 10 kg	11	3	10	102072	orderable	39	34	http://www.supp-102072.com/cat/hw/p3234.html
3350	Plasma Monitor 10/LE/VGA	10 inch low energy plasma monitor, VGA resolution	11	3	1	102068	orderable	740	630	http://www.supp-102068.com/cat/hw/p3350.html
2236	Plasma Monitor 10/TFT/XGA	10 inch TFT XGA flatscreen monitor for laptop computers	11	3	1	102090	under development	964	863	http://www.supp-102090.com/cat/hw/p2236.html
3054	Plasma Monitor 10/XGA	10 inch standard plasma monitor, XGA resolution. This virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.	11	3	1	102060	orderable	600	519	http://www.supp-102060.com/cat/hw/p3054.html
1782	Compact 400/DQ	400 characters per second high-speed draft printer. Dimensions (HxWxD): 17.34 x 24.26 x 26.32 inch. Interface: RS-232 serial (9-pin), no expansion slots. Paper size: A4, US Letter.	12	4	-5	102088	obsolete	125	108	http://www.supp-102088.com/cat/hw/p1782.html
2430	Compact 400/LQ	400 characters per second high-speed letter-quality printer. Dimensions (HxWxD): 12.37 x 27.96 x 23.92 inch. Interface: RS-232 serial (25-pin), 3 expansion slots. Paper size: A2, A3, A4.	12	4	2	102087	orderable	175	143	http://www.supp-102087.com/cat/hw/p2430.html
1792	Industrial 600/DQ	Wide carriage color capability 600 characters per second high-speed draft printer. Dimensions (HxWxD): 22.31 x 25.73 x 20.12 inch. Paper size: 3×5 inch to 11×17 inch full bleed wide format.	12	4	5	102088	orderable	225	180	http://www.supp-102088.com/cat/hw/p1792.html
1791	Industrial 700/HD	700 characters per second dot-matrix printer with harder body and dust protection for industrial uses. Interface: Centronics parallel, IEEE 1284 compliant. Paper size: 3×5 inch to 11×17 inch full bleed wide format. Memory: 4MB. Dimensions (HxWxD): 9.3 x 16.5 x 13 inch.	12	5	5	102086	orderable	275	239	http://www.supp-102086.com/cat/hw/p1791.html
2302	Inkjet B/6	Inkjet Printer, black and white, 6 pages per minute, resolution 600×300 dpi. Interface: Centronics parallel, IEEE 1284 compliant. Dimensions (HxWxD): 7.3 x 17.5 x 14 inch. Paper size: A3, A4, US legal. No expansion slots.	12	3	2	102096	orderable	150	121	http://www.supp-102096.com/cat/hw/p2302.html
2453	Inkjet C/4	Inkjet Printer, color (with two separate ink cartridges), 6 pages per minute black and white, 4 pages per minute color, resolution 600×300 dpi. Interface: Biodirectional IEEE 1284 compliant parallel interface and RS-232 serial (9-pin) interface 2 open EIO expansion slots. Memory: 8MB 96KB receiver buffer.	12	3	2	102090	orderable	195	174	http://www.supp-102090.com/cat/hw/p2453.html
2810	Inkvisible Pens	Rollerball pen is equipped with a smooth precision tip. See-through rubber grip allows for a visible ink supply and comfortable writing. 4-pack with 1 each, black, blue, red, green.	32	1	0	103095	orderable	6	4	http://www.supp-103095.com/cat/off/p2810.html
2870	Pencil – Mech	Ergonomically designed mechanical pencil for improved writing comfort. Refillable erasers and leads. Available in three lead sizes: .5mm (fine); .7mm (medium); and .9mm (thick).	32	1	2	103097	orderable	5	4	http://www.supp-103097.com/cat/off/p2870.html
1781	CDW 20/48/E	CD Writer, read 48x, write 20x	17	2	-9	102060	orderable	233	206	http://www.supp-102060.com/cat/hw/p1781.html
2264	CDW 20/48/I	CD-ROM drive: read 20x, write 48x (internal)	17	2	-9	102060	orderable	223	181	http://www.supp-102060.com/cat/hw/p2264.html
2260	DFD 1.44/3.5	Dual Floppy Drive – 1.44 MB – 3.5	17	2	-6	102062	orderable	67	54	http://www.supp-102062.com/cat/hw/p2260.html
2266	DVD 12x	DVD-ROM drive: speed 12x	17	3	1	102099	orderable	333	270	http://www.supp-102099.com/cat/hw/p2266.html
3077	DVD 8x	DVD – ROM drive, 8x speed. Will probably become obsolete pretty soon…	17	3	1	102099	orderable	274	237	http://www.supp-102099.com/cat/hw/p3077.html
2259	FD 1.44/3.5	Floppy Drive – 1.44 MB High Density capacity – 3.5 inch chassis	17	1	-9	102086	orderable	39	32	http://www.supp-102086.com/cat/hw/p2259.html
2261	FD 1.44/3.5/E	Floppy disk drive – 1.44 MB (high density) capacity – 3.5 inch (external)	17	2	-9	102086	orderable	42	37	http://www.supp-102086.com/cat/hw/p2261.html
3082	Modem – 56/90/E	Modem – 56kb per second, v.90 PCI Global compliant. External; for power supply 110V.	17	1	1	102068	orderable	81	72	http://www.supp-102068.com/cat/hw/p3082.html
2270	Modem – 56/90/I	Modem – 56kb per second, v.90 PCI Global compliant. Internal, for standard chassis (3.5 inch).	17	1	1	102068	orderable	66	56	http://www.supp-102068.com/cat/hw/p2270.html
2268	Modem – 56/H/E	Standard Hayes compatible modem – 56kb per second, external. Power supply: 220V.	17	1	1	102068	obsolete	77	67	http://www.supp-102068.com/cat/hw/p2268.html
3083	Modem – 56/H/I	Standard Hayes modem – 56kb per second, internal, for standard 3.5 inch chassis.	17	1	1	102068	orderable	67	56	http://www.supp-102068.com/cat/hw/p3083.html
2374	Modem – C/100	DOCSIS/EURODOCSIS 1.0/1.1-compliant external cable modem	17	2	-5	102064	orderable	65	54	http://www.supp-102064.com/cat/hw/p2374.html
1740	TD 12GB/DAT	Tape drive – 12 gigabyte capacity, DAT format.	17	2	-5	102075	orderable	134	111	http://www.supp-102075.com/cat/hw/p1740.html
2409	TD 7GB/8	Tape drive, 7GB capacity, 8mm cartridge tape.	17	2	-5	102054	orderable	210	177	http://www.supp-102054.com/cat/hw/p2409.html
2262	ZIP 100	ZIP Drive, 100 MB capacity (external) plus cable for parallel port connection	17	2	-5	102054	orderable	98	81	http://www.supp-102054.com/cat/hw/p2262.html
2522	Battery – EL	Extended life battery, for laptop computers	19	2	-3	102078	orderable	44	39	http://www.supp-102078.com/cat/hw/p2522.html
2278	Battery – NiHM	Rechargeable NiHM battery for laptop computers	19	1	-3	102078	orderable	55	48	http://www.supp-102078.com/cat/hw/p2278.html
2418	Battery Backup (DA-130)	Single-battery charger with LED indicators	19	1	-3	102074	orderable	61	52	http://www.supp-102074.com/cat/hw/p2418.html
2419	Battery Backup (DA-290)	Two-battery charger with LED indicators	19	1	-3	102074	orderable	72	60	http://www.supp-102074.com/cat/hw/p2419.html
3097	Cable Connector – 32R	Cable Connector – 32 pin ribbon	19	1	0	102055	orderable	3	2	http://www.supp-102055.com/cat/hw/p3097.html
3099	Cable Harness	Cable harness to organize and bundle computer wiring	19	1	0	102055	orderable	4	3	http://www.supp-102055.com/cat/hw/p3099.html
2380	Cable PR/15/P	15 foot parallel printer cable	19	2	-1	102055	orderable	6	5	http://www.supp-102055.com/cat/hw/p2380.html
2408	Cable PR/P/6	Standard Centronics 6ft printer cable, parallel port	19	1	-1	102055	orderable	4	3	http://www.supp-102055.com/cat/hw/p2408.html
2457	Cable PR/S/6	Standard RS232 serial printer cable, 6 feet	19	1	-1	102055	orderable	5	4	http://www.supp-102055.com/cat/hw/p2457.html
2373	Cable RS232 10/AF	10 ft RS232 cable with F/F and 9F/25F adapters	19	2	1	102055	orderable	6	4	http://www.supp-102055.com/cat/hw/p2373.html
1734	Cable RS232 10/AM	10 ft RS232 cable with M/M and 9M/25M adapters	19	2	1	102055	orderable	6	5	http://www.supp-102055.com/cat/hw/p1734.html
1737	Cable SCSI 10/FW/ADS	10ft SCSI2 F/W Adapt to DSxx0 Cable	19	2	-2	102095	orderable	8	6	http://www.supp-102095.com/cat/hw/p1737.html
1745	Cable SCSI 20/WD->D	20ft SCSI2 Wide Disk Store to Disk Store Cable	19	2	-2	102095	orderable	9	7	http://www.supp-102095.com/cat/hw/p1745.html
2982	Drive Mount – A	Drive Mount assembly kit	19	2	-1	102057	orderable	44	35	http://www.supp-102057.com/cat/hw/p2982.html
3277	Drive Mount – A/T	Drive Mount assembly kit for tower PC	19	2	1	102057	orderable	36	29	http://www.supp-102057.com/cat/hw/p3277.html
2976	Drive Mount – D	Drive Mount for desktop PC	19	2	1	102057	orderable	52	44	http://www.supp-102057.com/cat/hw/p2976.html
3204	Envoy DS	Envoy Docking Station	19	3	2	102060	orderable	126	107	http://www.supp-102060.com/cat/hw/p3204.html
2638	Envoy DS/E	Enhanced Envoy Docking Station	19	3	2	102060	orderable	137	111	http://www.supp-102060.com/cat/hw/p2638.html
3020	Envoy IC	Envoy Internet Computer, Plug&Play	19	4	1	102060	orderable	449	366	http://www.supp-102060.com/cat/hw/p3020.html
1948	Envoy IC/58	Internet computer with built-in 58K modem	19	4	-5	102060	orderable	498	428	http://www.supp-102060.com/cat/hw/p1948.html
3003	Laptop 128/12/56/v90/110	Envoy Laptop, 128MB memory, 12GB hard disk, v90 modem, 110V power supply.	19	4	-5	102060	orderable	3219	2606	http://www.supp-102060.com/cat/hw/p3003.html
2999	Laptop 16/8/110	Envoy Laptop, 16MB memory, 8GB hard disk, 110V power supply (US only).	19	3	-5	102060	obsolete	999	800	http://www.supp-102060.com/cat/hw/p2999.html
3000	Laptop 32/10/56	Envoy Laptop, 32MB memory, 10GB hard disk, 56K Modem, universal power supply (switchable).	19	4	-5	102060	orderable	1749	1542	http://www.supp-102060.com/cat/hw/p3000.html
3001	Laptop 48/10/56/110	Envoy Laptop, 48MB memory, 10GB hard disk, 56K modem, 110V power supply.	19	4	-5	102060	obsolete	2556	2073	http://www.supp-102060.com/cat/hw/p3001.html
3004	Laptop 64/10/56/220	Envoy Laptop, 64MB memory, 10GB hard disk, 56K modem, 220V power supply.	19	4	-5	102060	orderable	2768	2275	http://www.supp-102060.com/cat/hw/p3004.html
3391	PS 110/220	Power Supply – switchable, 110V/220V	19	2	-5	102062	orderable	85	75	http://www.supp-102062.com/cat/hw/p3391.html
3124	PS 110V /T	Power supply for tower PC, 110V	19	2	1	102062	orderable	84	70	http://www.supp-102062.com/cat/hw/p3124.html
1738	PS 110V /US	110 V Power Supply – US compatible	19	2	1	102062	orderable	86	70	http://www.supp-102062.com/cat/hw/p1738.html
2377	PS 110V HS/US	110 V hot swappable power supply – US compatible	19	2	1	102062	orderable	97	82	http://www.supp-102062.com/cat/hw/p2377.html
2299	PS 12V /P	Power Supply – 12v portable	19	2	1	102062	orderable	76	64	http://www.supp-102062.com/cat/hw/p2299.html
2414	HD 9.1GB @10000 /I	9.1 GB SCSI hard disk @ 10000 RPM (internal). Supra7 disk drives are available in 10,000 RPM spindle speeds and capacities of 18GB and 9.1 GB. SCSI and RS-232 interfaces.	13	3	5	102098	orderable	454	399	http://www.supp-102098.com/cat/hw/p2414.html
2415	HD 9.1GB @7200	9.1 GB hard disk @ 7200 RPM. Universal option kits are configured and pre-mounted in the appropriate hot plug tray for immediate installation into your corporate server or storage system.	13	3	5	102063	orderable	359	309	http://www.supp-102063.com/cat/hw/p2415.html
2395	32MB Cache /M	32MB Mirrored cache memory (100-MHz Registered SDRAM)	14	1	-6	102093	orderable	123	109	http://www.supp-102093.com/cat/hw/p2395.html
1755	32MB Cache /NM	32MB Non-Mirrored cache memory	14	1	-6	102076	orderable	121	99	http://www.supp-102076.com/cat/hw/p1755.html
2406	64MB Cache /M	64MB Mirrored cache memory	14	1	-6	102059	orderable	223	178	http://www.supp-102059.com/cat/hw/p2406.html
2404	64MB Cache /NM	64 MB Non-mirrored cache memory. FPM memory chips are implemented on 5 volt SIMMs, but are also available on 3.3 volt DIMMs.	14	1	-6	102087	orderable	221	180	http://www.supp-102087.com/cat/hw/p2404.html
1770	8MB Cache /NM	8MB Non-Mirrored Cache Memory (100-MHz Registered SDRAM)	14	1	-6	102050	orderable	–	73	http://www.supp-102050.com/cat/hw/p1770.html
2412	8MB EDO Memory	8 MB 8×32 EDO SIM memory. Extended Data Out memory differs from FPM in a small, but significant design change. Unlike FPM, the data output drivers for EDO remain on when the memory controller removes the column address to begin the next cycle. Therefore, a new data cycle can begin before the previous cycle has completed. EDO is available on SIMMs and DIMMs, in 3.3 and 5 volt varieties.	14	1	-6	102058	obsolete	98	83	http://www.supp-102058.com/cat/hw/p2412.html
2378	DIMM – 128 MB	128 MB DIMM memory. The main reason for the change from SIMMs to DIMMs is to support the higher bus widths of 64-bit processors. DIMMs are 64- or 72-bits wide; SIMMs are only 32- or 36-bits wide (with parity).	14	1	-6	102050	orderable	305	247	http://www.supp-102050.com/cat/hw/p2378.html
3087	DIMM – 16 MB	Citrus OLX DIMM – 16 MB capacity.	14	1	-6	102081	obsolete	124	99	http://www.supp-102081.com/cat/hw/p3087.html
2384	DIMM – 1GB	Memory DIMM: RAM – 1 GB capacity.	14	1	-6	102074	under development	599	479	http://www.supp-102074.com/cat/hw/p2384.html
1749	DIMM – 256MB	Memory DIMM: RAM 256 MB. (100-MHz Registered SDRAM)	14	1	-6	102053	orderable	337	300	http://www.supp-102053.com/cat/hw/p1749.html
1750	DIMM – 2GB	Memory DIMM: RAM, 2 GB capacity.	14	1	-6	102052	orderable	699	560	http://www.supp-102052.com/cat/hw/p1750.html
2394	DIMM – 32MB	32 MB DIMM Memory upgrade	14	1	-6	102054	orderable	128	106	http://www.supp-102054.com/cat/hw/p2394.html
2400	DIMM – 512 MB	512 MB DIMM memory. Improved memory upgrade granularity: Fewer DIMMs are required to upgrade a system than it would require if using SIMMs in the same system. Increased maximum memory ceilings: Given the same number of memory slots, the maximum memory of a system using DIMMs is more than one using SIMMs. DIMMs have separate contacts on each side of the board, which provide two times the data rate as one SIMM.	14	1	1	102098	under development	448	380	http://www.supp-102098.com/cat/hw/p2400.html
1763	DIMM – 64MB	Memory DIMM: RAM, 64MB (100-MHz Unregistered ECC SDRAM)	14	1	1	102069	orderable	247	202	http://www.supp-102069.com/cat/hw/p1763.html
2396	EDO – 32MB	Memory EDO SIM: RAM, 32 MB (100-MHz Unregistered ECC SDRAM). Like FPM, EDO is available on SIMMs and DIMMs, in 3.3 and 5 volt varieties If EDO memory is installed in a computer that was not designed to support it, the memory may not work.	14	1	-6	102051	orderable	179	149	http://www.supp-102051.com/cat/hw/p2396.html
2272	RAM – 16 MB	Memory SIMM: RAM – 16 MB capacity.	14	1	1	102074	obsolete	135	110	http://www.supp-102074.com/cat/hw/p2272.html
2274	RAM – 32 MB	Memory SIMM: RAM – 32 MB capacity.	14	1	1	102064	orderable	161	135	http://www.supp-102064.com/cat/hw/p2274.html
3090	RAM – 48 MB	Random Access Memory, SIMM – 48 MB capacity.	14	1	1	102084	orderable	193	170	http://www.supp-102084.com/cat/hw/p3090.html
1739	SDRAM – 128 MB	SDRAM memory, 128 MB capacity. SDRAM can access data at speeds up to 100 MHz, which is up to four times as fast as standard DRAMs. The advantages of SDRAM can be fully realized, however, only by computers designed to support SDRAM. SDRAM is available on 5 and 3.3 volt DIMMs.	14	1	-9	102077	orderable	299	248	http://www.supp-102077.com/cat/hw/p1739.html
3359	SDRAM – 16 MB	SDRAM memory upgrade module, 16 MB. Synchronous Dynamic Random Access Memory was introduced after EDO. Its architecture and operation are based on those of the standard DRAM, but SDRAM provides a revolutionary change to main memory that further reduces data retrieval times. SDRAM is synchronized to the system clock that controls the CPU. This means that the system clock controlling the functions of the microprocessor also controls the SDRAM functions. This enables the memory controller to know on which clock cycle a data request will be ready, and therefore eliminates timing delays.	14	1	-9	102059	orderable	111	99	http://www.supp-102059.com/cat/hw/p3359.html
3088	SDRAM – 32 MB	SDRAM module with ECC – 32 MB capacity. SDRAM has multiple memory banks that can work simultaneously. Switching between banks allows for a continuous data flow.	14	1	-9	102057	orderable	258	220	http://www.supp-102057.com/cat/hw/p3088.html
2276	SDRAM – 48 MB	Memory SIMM: RAM – 48 MB. SDRAM can operate in burst mode. In burst mode, when a single data address is accessed, an entire block of data is retrieved rather than just the one piece. The assumption is that the next piece of data that will be requested will be sequential to the previous. Since this is usually the case, data is held readily available.	14	1	-9	102058	orderable	269	215	http://www.supp-102058.com/cat/hw/p2276.html
3086	VRAM – 16 MB	Citrus Video RAM module – 16 MB capacity. VRAM is used by the video system in a computer to store video information and is reserved exclusively for video operations. It was developed to provide continuous streams of serial data for refreshing video screens.	14	1	-6	102056	orderable	211	186	http://www.supp-102056.com/cat/hw/p3086.html
3091	VRAM – 64 MB	Citrus Video RAM memory module – 64 MB capacity. Physically, VRAM looks just like DRAM with added hardware called a shift register. The special feature of VRAM is that it can transfer one entire row of data (up to 256 bits) into this shift register in a single clock cycle. This ability significantly reduces retrieval time, since the number of fetches is reduced from a possible 256 to a single fetch. The main benefit of having a shift register available for data dumps is that it frees the CPU to refresh the screen rather than retrieve data, thereby doubling the data bandwidth. For this reason, VRAM is often referred to as being dual-ported. However, the shift register will only be used when the VRAM chip is given special instructions to do so. The command to use the shift register is built into the graphics controller.	14	1	-6	102098	orderable	279	243	http://www.supp-102098.com/cat/hw/p3091.html
1787	CPU D300	Dual CPU @ 300Mhz. For light personal processing only, or file servers with less than 5 concurrent users. This product will probably become obsolete soon.	15	1	3	102097	orderable	101	90	http://www.supp-102097.com/cat/hw/p1787.html
2439	CPU D400	Dual CPU @ 400Mhz. Good price/performance ratio; for mid-size LAN file servers (up to 100 concurrent users).	15	1	3	102092	orderable	123	105	http://www.supp-102092.com/cat/hw/p2439.html
1788	CPU D600	Dual CPU @ 600Mhz. State of the art, high clock speed; for heavy load WAN servers (up to 200 concurrent users).	15	1	5	102067	orderable	178	149	http://www.supp-102067.com/cat/hw/p1788.html
2375	GP 1024×768	Graphics Processor, resolution 1024 X 768 pixels. Outstanding price/performance for 2D and 3D applications under SPNIX v3.3 and v4.0. Double your viewing power by running two monitors from this single card. Two 17 inch monitors have more screen area than one 21 inch monitor. Excellent option for users that multi-task frequently or access data from multiple sources often.	15	1	-9	102063	orderable	78	69	http://www.supp-102063.com/cat/hw/p2375.html
2411	GP 1280×1024	Graphics Processor, resolution 1280 X 1024 pixels. High end 3D performance at a mid range price: 15 million Gouraud shaded triangles per second, Optimized 3D drivers for MCAD and DCC applications, with user-customizable settings. 64MB DDR SDRAM unified frame buffer supporting true color at all supported standard resolutions.	15	1	1	102061	orderable	98	78	http://www.supp-102061.com/cat/hw/p2411.html
1769	GP 800×600	Graphics processor, resolution 800 x 600 pixels. Remarkable value for users requiring great 2D capabilities or general 3D support for advanced applications. Drives incredible performance in highly complex models and frees the customer to focus on the design, instead of the rendering process.	15	1	-6	102050	orderable	48	–	http://www.supp-102050.com/cat/hw/p1769.html
2049	MB – S300	PC type motherboard, 300 Series.	15	2	1	102082	obsolete	55	47	http://www.supp-102082.com/cat/hw/p2049.html
2751	MB – S450	PC type motherboard, 450 Series.	15	2	1	102072	orderable	66	54	http://www.supp-102072.com/cat/hw/p2751.html
3112	MB – S500	PC type motherboard, 500 Series.	15	2	-5	102086	orderable	77	66	http://www.supp-102086.com/cat/hw/p3112.html
2752	MB – S550	PC type motherboard for the 550 Series.	15	2	-5	102086	orderable	88	76	http://www.supp-102086.com/cat/hw/p2752.html
2293	MB – S600	Motherboard, 600 Series.	15	2	2	102086	orderable	99	87	http://www.supp-102086.com/cat/hw/p2293.html
3114	MB – S900/650+	PC motherboard, 900 Series; standard motherboard for all models 650 and up.	15	3	0	102086	under development	101	88	http://www.supp-102086.com/cat/hw/p3114.html
3129	Sound Card STD	Sound Card – standard version, with MIDI interface, line in/out, low impedance microphone input.	15	1	-6	102090	orderable	46	39	http://www.supp-102090.com/cat/hw/p3129.html
3133	Video Card /32	Video Card, with 32MB cache memory.	15	2	-6	102076	orderable	48	41	http://www.supp-102076.com/cat/hw/p3133.html
2308	Video Card /E32	3-D ELSA Video Card, with 32 MB memory.	15	2	-6	102087	orderable	58	48	http://www.supp-102087.com/cat/hw/p2308.html
2496	WSP DA-130	Wide storage processor DA-130 for storage subunits.	15	2	0	102067	planned	299	244	http://www.supp-102067.com/cat/hw/p2496.html
2497	WSP DA-290	Wide storage processor (model DA-290).	15	3	0	102053	planned	399	355	http://www.supp-102053.com/cat/hw/p2497.html
3106	KB 101/EN	Standard PC/AT Enhanced Keyboard (101/102-Key). Input locale: English (US).	16	1	1	102066	orderable	48	41	http://www.supp-102066.com/cat/hw/p3106.html
2289	KB 101/ES	Standard PC/AT Enhanced Keyboard (101/102-Key). Input locale: Spanish.	16	1	1	102055	orderable	48	38	http://www.supp-102055.com/cat/hw/p2289.html
3110	KB 101/FR	Standard PC/AT Enhanced Keyboard (101/102-Key). Input locale: French.	16	1	1	102055	orderable	48	39	http://www.supp-102055.com/cat/hw/p3110.html
3108	KB E/EN	Ergonomic Keyboard with two separate key areas, detachable numeric pad. Key layout: English (US).	16	2	2	102055	orderable	78	63	http://www.supp-102055.com/cat/hw/p3108.html
2058	Mouse +WP	Combination of a mouse and a wrist pad for more comfortable typing and mouse operation.	16	1	1	102055	orderable	23	19	http://www.supp-102055.com/cat/hw/p2058.html
2761	Mouse +WP/CL	Set consisting of a mouse and wrist pad, with corporate logo	16	1	-5	102099	planned	27	23	http://www.supp-102099.com/cat/hw/p2761.html
3117	Mouse C/E	Ergonomic, cordless mouse. With track-ball for maximum comfort and ease of use.	16	1	1	102099	orderable	41	35	http://www.supp-102099.com/cat/hw/p3117.html
2056	Mouse Pad /CL	Standard mouse pad, with corporate logo	16	1	1	102099	planned	8	6	http://www.supp-102099.com/cat/hw/p2056.html
2211	Wrist Pad	A foam strip to support your wrists when using a keyboard	16	1	1	102072	orderable	4	3	http://www.supp-102072.com/cat/hw/p2211.html
2944	Wrist Pad /CL	Wrist Pad with corporate logo	16	1	1	102063	under development	3	2	http://www.supp-102063.com/cat/hw/p2944.html
1742	CD-ROM 500/16x	CD drive, read only, speed 16x, maximum capacity 500 MB.	17	1	-6	102052	orderable	101	81	http://www.supp-102052.com/cat/hw/p1742.html
2402	CD-ROM 600/E/24x	600 MB external 24x speed CD-ROM drive (read only).	17	2	-9	102052	orderable	127	113	http://www.supp-102052.com/cat/hw/p2402.html
2403	CD-ROM 600/I/24x	600 MB internal read only CD-ROM drive, reading speed 24x	17	2	1	102052	orderable	117	103	http://www.supp-102052.com/cat/hw/p2403.html
1761	CD-ROM 600/I/32x	600 MB Internal CD-ROM Drive, speed 32x (read only).	17	2	1	102052	under development	134	119	http://www.supp-102052.com/cat/hw/p1761.html
2381	CD-ROM 8x	CD Writer, read only, speed 8x	17	1	-3	102052	obsolete	99	82	http://www.supp-102052.com/cat/hw/p2381.html
2424	CDW 12/24	CD Writer, speed 12x write, 24x read. Warning: will become obsolete very soon; this speed is not high enough anymore, and better alternatives are available for a reasonable price.	17	2	-6	102075	orderable	221	198	http://www.supp-102075.com/cat/hw/p2424.html
1726	LCD Monitor 11/PM	Liquid Cristal Display 11 inch passive monitor. The virtually-flat, high-resolution screen delivers outstanding image quality with reduced glare.	11	3	-3	102067	under development	259	208	http://www.www.supp-102067.com/cat/hw/p1726.html
2359	LCD Monitor 9/PM	Liquid Cristal Display 9 inch passive monitor. Enjoy the productivity that a small monitor can bring via more workspace on your desk. Easy setup with plug-and-play compatibility.	11	3	-3	102061	orderable	249	206	http://www.www.supp-102061.com/cat/hw/p2359.html
3060	Monitor 17/HR	CRT Monitor 17 inch (16 viewable) high resolution. Exceptional image performance and the benefit of additional screen space. This monitor offers sharp, color-rich monitor performance at an incredible value. With a host of leading features, including on-screen display controls.	11	4	-6	102081	orderable	299	250	http://www.supp-102081.com/cat/hw/p3060.html
3051	Pens – 10/MP	Permanent ink pen dries quickly and is smear resistant. Provides smooth, skip-free writing. Medium point. Single color boxes (black, blue, red) or assorted box (6 black, 3 blue, and 1 red).	32	1	0	103097	orderable	12	10	http://www.supp-103097.com/cat/off/p3051.html
3150	Card Holder – 25	Card Holder; heavy plastic business card holder with embossed corporate logo. Holds about 25 of your business cards, depending on card thickness.	32	1	-6	103089	orderable	18	15	http://www.supp-103089.com/cat/off/p3150.html
3208	Pencils – Wood	Box of 2 dozen wooden pencils. Specify lead type when ordering: 2H (double hard), H (hard), HB (hard black), B (soft black).	32	1	0	103097	orderable	2	1	http://www.supp-103097.com/cat/off/p3208.html
3209	Sharpener – Pencil	Electric Pencil Sharpener Rugged steel cutters for long life. PencilSaver helps prevent over-sharpening. Non-skid rubber feet. Built-in pencil holder.	32	2	2	103096	orderable	13	11	http://www.supp-103096.com/cat/off/p3209.html
3224	Card Organizer – 250	Portable holder for organizing business cards, capacity 250. Booklet style with slip in, transparent pockets for business cards. Optional alphabet tabs. Specify cover color when ordering (dark brown, beige, burgundy, black, and light grey).	32	1	5	103095	orderable	32	28	http://www.supp-103095.com/cat/off/p3224.html
3225	Card Organizer – 1000	Holder for organizing business cards with alphabet dividers; capacity 1000. Desk top style with smoke grey cover and black base. Lid is removable for storing inside drawer.	32	1	-2	103095	orderable	47	39	http://www.supp-103095.com/cat/off/p3225.html
3511	Paper – HQ Printer	Quality paper for inkjet and laser printers tested to resist printer jams. Acid free for archival purposes. 22lb. weight with brightness of 92. Size: 8 1/2 x 11. Single 500-sheet ream.	32	2	0	103080	orderable	9	7	http://www.supp-103080.com/cat/off/p3511.html
3515	Lead Replacement	Refill leads for mechanical pencils. Each pack contains 25 leads and a replacement eraser. Available in three lead sizes: .5mm (fine); .7mm (medium); and .9mm (thick).	32	1	0	103095	orderable	2	1	http://www.supp-103095.com/cat/off/p3515.html
2986	Manual – Vision OS/2x +	Manuals for Vision Operating System V 2.x and Vision Office Suite	33	3	0	103095	orderable	125	111	http://www.supp-103095.com/cat/off/p2986.html
3163	Manual – Vision Net6.3/US	Vision Networking V6.3 Reference Manual. US version with advanced encryption.	33	2	0	103083	orderable	35	29	http://www.supp-103083.com/cat/off/p3163.html
3165	Manual – Vision Tools2.0	Vision Business Tools Suite V2.0 Reference Manual. Includes installation, configuration, and user guide.	33	2	0	103083	orderable	40	34	http://www.supp-103083.com/cat/off/p3165.html
3167	Manual – Vision OS/2.x	Vision Operating System V2.0/2.1/2/3 Reference Manual. Complete installation, configuration, management, and tuning information for Vision system administration. Note that this manual replaces the individual Version 2.0 and 2.1 manuals.	33	2	0	103083	orderable	55	47	http://www.supp-103083.com/cat/off/p3167.html
3216	Manual – Vision Net6.3	Vision Networking V6.3 Reference Manual. Non-US version with basic encryption.	33	2	0	103083	orderable	30	26	http://www.supp-103083.com/cat/off/p3216.html
3220	Manual – Vision OS/1.2	Vision Operating System V1.2 Reference Manual. Complete installation, configuration, management, and tuning information for Vision system administration.	33	2	0	103083	orderable	45	36	http://www.supp-103083.com/cat/off/p3220.html
1729	Chemicals – RCP	Cleaning Chemicals – 3500 roller clean pads	39	2	5	103094	orderable	80	66	http://www.supp-103094.com/cat/off/p1729.html
1910	FG Stock – H	Fiberglass Stock – heavy duty, 1 thick	39	3	0	103083	orderable	14	11	http://www.supp-103083.com/cat/off/p1910.html
1912	SS Stock – 3mm	Stainless steel stock – 3mm. Can be predrilled for standard power supplies, motherboard holders, and hard drives. Please use appropriate template to identify model number, placement, and size of finished sheet when placing order for drilled sheet.	39	2	0	103083	orderable	15	12	http://www.supp-103083.com/cat/off/p1912.html
1940	ESD Bracelet/Clip	Electro static discharge bracelet with alligator clip for easy connection to computer chassis or other ground.	39	1	-5	103095	orderable	18	14	http://www.supp-103095.com/cat/off/p1940.html
2030	Latex Gloves	Latex Gloves for assemblers, chemical handlers, fitters. Heavy duty, safety orange, with textured grip on fingers and thumb. Waterproof and shock-proof up to 220 volts/2 amps, 110 volts/5 amps. Acid proof for up to 5 minutes.	39	1	10	103097	orderable	12	10	http://www.supp-103097.com/cat/off/p2030.html
2326	Plastic Stock – Y	Plastic Stock – Yellow, standard quality.	39	1	0	103093	orderable	2	1	http://www.supp-103093.com/cat/off/p2326.html
2330	Plastic Stock – R	Plastic Stock – Red, standard quality.	39	1	0	103093	orderable	2	1	http://www.supp-103093.com/cat/off/p2330.html
2334	Resin	General purpose synthetic resin.	39	2	0	103087	orderable	4	3	http://www.supp-103087.com/cat/off/p2334.html
2340	Chemicals – SW	Cleaning Chemicals – 3500 staticide wipes	39	2	5	103094	orderable	72	59	http://www.supp-103094.com/cat/off/p2340.html
2365	Chemicals – TCS	Cleaning Chemical – 2500 transport cleaning sheets	39	3	5	103094	orderable	78	69	http://www.supp-103094.com/cat/off/p2365.html
2594	FG Stock – L	Fiberglass Stock – light weight for internal heat shielding, 1/4 thick	39	2	0	103098	orderable	9	7	http://www.supp-103098.com/cat/off/p2594.html
2596	SS Stock – 1mm	Stainless steel stock – 3mm. Can be predrilled for standard model motherboard and battery holders. Please use appropriate template to identify model number, placement, and size of finished sheet when placing order for drilled sheet.	39	2	0	103098	orderable	12	10	http://www.supp-103098.com/cat/off/p2596.html
2631	ESD Bracelet/QR	Electro Static Discharge Bracelet: 2 piece lead with quick release connector. One piece stays permanently attached to computer chassis with screw, the other is attached to the bracelet. Additional permanent ends available.	39	1	-5	103085	orderable	15	12	http://www.supp-103085.com/cat/off/p2631.html
2721	PC Bag – L/S	Black Leather Computer Case – single laptop capacity with pockets for manuals, additional hardware, and work papers. Adjustable protective straps and removable pocket for power supply and cables.	39	2	1	103095	orderable	87	70	http://www.supp-103095.com/cat/off/p2721.html
2722	PC Bag – L/D	Black Leather Computer Case – double laptop capacity with pockets for additional hardware or manuals and work papers. Adjustable protective straps and removable pockets for power supplies and cables. Double wide shoulder strap for comfort.	39	2	1	103095	orderable	112	99	http://www.supp-103095.com/cat/off/p2722.html
2725	Machine Oil	Machine Oil for Lubrication of CD-ROM drive doors and slides. Self-cleaning adjustable nozzle for fine to medium flow.	39	1	0	103098	orderable	4	3	http://www.supp-103098.com/cat/off/p2725.html
2782	PC Bag – C/S	Canvas Computer Case – single laptop capacity with pockets for manuals, additional hardware, and work papers. Adjustable protective straps and removable pocket for power supply and cables. Outside pocket with snap closure for easy access while travelling.	39	2	-6	103095	orderable	62	50	http://www.supp-103095.com/cat/off/p2782.html
3187	Plastic Stock – B/HD	Plastic Stock – Blue, high density.	39	1	0	103095	orderable	3	2	http://www.supp-103095.com/cat/off/p3187.html
3189	Plastic Stock – G	Plastic Stock – Green, standard density.	39	1	0	103095	orderable	2	1	http://www.supp-103095.com/cat/off/p3189.html
3191	Plastic Stock – O	Plastic Stock – Orange, standard density.	39	1	0	103095	orderable	2	1	http://www.supp-103095.com/cat/off/p3191.html
3193	Plastic Stock – W/HD	Plastic Stock – White, high density.	39	1	0	103095	orderable	3	2	http://www.supp-103095.com/cat/off/p3193.html
3123	PS 220V /D	Standard power supply, 220V, for desktop computers.	19	2	1	102062	orderable	81	65	http://www.supp-102062.com/cat/hw/p3123.html
1748	PS 220V /EUR	220 Volt Power supply type – Europe	19	2	1	102053	orderable	83	70	http://www.supp-102053.com/cat/hw/p1748.html
2387	PS 220V /FR	220V Power supply type – France	19	2	1	102053	orderable	83	66	http://www.supp-102053.com/cat/hw/p2387.html
2370	PS 220V /HS/FR	220V hot swappable power supply, for France.	19	2	-9	102053	orderable	91	75	http://www.supp-102053.com/cat/hw/p2370.html
2311	PS 220V /L	Power supply for laptop computers, 220V	19	2	-9	102053	orderable	95	79	http://www.supp-102053.com/cat/hw/p2311.html
1733	PS 220V /UK	220V Power supply type – United Kingdom	19	2	-9	102080	orderable	89	76	http://www.supp-102080.com/cat/hw/p1733.html
2878	Router – ASR/2W	Special ALS Router – Approved Supplier required item with 2-way match	19	3	-9	102063	orderable	345	305	http://www.supp-102063.com/cat/hw/p2878.html
2879	Router – ASR/3W	Special ALS Router – Approved Supplier required item with 3-way match	19	3	-9	102063	orderable	456	384	http://www.supp-102063.com/cat/hw/p2879.html
2152	Router – DTMF4	DTMF 4 port router	19	3	-9	102063	obsolete	231	191	http://www.supp-102063.com/cat/hw/p2152.html
3301	Screws <B.28.P>	Screws: Brass, size 28mm, Phillips head. Plastic box, contents 500.	19	2	0	102071	orderable	15	12	http://www.supp-102071.com/cat/hw/p3301.html
3143	Screws <B.28.S>	Screws: Brass, size 28mm, straight. Plastic box, contents 500.	19	2	0	102071	orderable	16	13	http://www.supp-102071.com/cat/hw/p3143.html
2323	Screws <B.32.P>	Screws: Brass, size 32mm, Phillips head. Plastic box, contents 400.	19	3	0	102071	orderable	18	14	http://www.supp-102071.com/cat/hw/p2323.html
3134	Screws <B.32.S>	Screws: Brass, size 32mm, straight. Plastic box, contents 400.	19	3	0	102071	orderable	18	15	http://www.supp-102071.com/cat/hw/p3134.html
3139	Screws <S.16.S>	Screws: Steel, size 16 mm, straight. Carton box, contents 750.	19	2	0	102071	orderable	21	17	http://www.supp-102071.com/cat/hw/p3139.html
3300	Screws <S.32.P>	Screws: Steel, size 32mm, Phillips head. Plastic box, contents 400.	19	3	0	102071	orderable	23	19	http://www.supp-102071.com/cat/hw/p3300.html
2316	Screws <S.32.S>	Screws: Steel, size 32mm, straight. Plastic box, contents 500.	19	3	0	102074	orderable	22	19	http://www.supp-102074.com/cat/hw/p2316.html
3140	Screws <Z.16.S>	Screws: Zinc, length 16mm, straight. Carton box, contents 750.	19	2	0	102074	orderable	24	19	http://www.supp-102074.com/cat/hw/p3140.html
2319	Screws <Z.24.S>	Screws: Zinc, size 24mm, straight. Carton box, contents 500.	19	2	0	102074	orderable	25	21	http://www.supp-102074.com/cat/hw/p2319.html
2322	Screws <Z.28.P>	Screws: Zinc, size 28 mm, Phillips head. Carton box, contents 850.	19	2	0	102076	orderable	23	18	http://www.supp-102076.com/cat/hw/p2322.html
3178	Spreadsheet – SSP/V 2.0	SmartSpread Spreadsheet, Professional Edition Version 2.0, for Vision Release 11.1 and 11.2. Shrink wrap includes CD-ROM containing advanced software and online documentation, plus printed manual, tutorial, and license registration.	21	2	-1	103080	orderable	45	37	http://www.supp-103080.com/cat/sw/p3178.html
3179	Spreadsheet – SSS/S 2.1	SmartSpread Spreadsheet, Standard Edition Version 2.1, for SPNIX Release 4.0. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual and license registration.	21	2	-1	103080	orderable	50	44	http://www.supp-103080.com/cat/sw/p3179.html
3182	Word Processing – SWP/V 4.5	SmartWord Word Processor, Professional Edition Version 4.5, for Vision Release 11.x. Shrink wrap includes CD-ROM, containing advanced software, printed manual, and license registration.	22	2	-3	103093	orderable	65	54	http://www.supp-103093.com/cat/sw/p3182.html
3183	Word Processing – SWS/V 4.5	SmartWord Word Processor, Standard Edition Version 4.5, for Vision Release 11.x. Shrink wrap includes CD-ROM and license registration.	22	2	-1	103093	orderable	50	40	http://www.supp-103093.com/cat/sw/p3183.html
3197	Spreadsheet – SSS/V 2.1	SmartSpread Spreadsheet, Standard Edition Version 2.1, for Vision Release 11.1 and 11.2. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual, tutorial, and license registration.	21	2	-1	103080	orderable	45	36	http://www.supp-103080.com/cat/sw/p3197.html
3255	Spreadsheet – SSS/CD 2.2B	SmartSpread Spreadsheet, Standard Edition, Beta Version 2.2, for SPNIX Release 4.1. CD-ROM only.	21	1	-1	103080	orderable	35	30	http://www.supp-103080.com/cat/sw/p3255.html
3256	Spreadsheet – SSS/V 2.0	SmartSpread Spreadsheet, Standard Edition Version 2.0, for Vision Release 11.0. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual, tutorial, and license registration.	21	2	-1	103080	orderable	40	34	http://www.supp-103080.com/cat/sw/p3256.html
3260	Word Processing – SWP/S 4.4	SmartSpread Spreadsheet, Standard Edition Version 2.2, for SPNIX Release 4.x. Shrink wrap includes CD-ROM, containing software, plus printed manual and license registration.	22	2	-1	103093	orderable	50	41	http://www.supp-103093.com/cat/sw/p3260.html
3262	Spreadsheet – SSS/S 2.2	SmartSpread Spreadsheet, Standard Edition Version 2.2, for SPNIX Release 4.1. Shrink wrap includes CD-ROM containing software and online documentation, plus printed manual and license registration.	21	2	-1	103080	under development	50	41	http://www.supp-103080.com/cat/sw/p3262.html
3361	Spreadsheet – SSP/S 1.5	SmartSpread Spreadsheet, Standard Edition Version 1.5, for SPNIX Release 3.3. Shrink wrap includes CD-ROM containing advanced software and online documentation, plus printed manual, tutorial, and license registration.	21	2	-1	103080	orderable	40	34	http://www.supp-103080.com/cat/sw/p3361.html
1799	SPNIX3.3 – SL	Operating System Software: SPNIX V3.3 – Base Server License. Includes 10 general licenses for system administration, developers, or users. No network user licensing.	24	1	1	103092	orderable	1000	874	http://www.supp-103092.com/cat/sw/p1799.html
1801	SPNIX3.3 – AL	Operating System Software: SPNIX V3.3 – Additional system administrator license, including network access.	24	1	1	103092	orderable	100	88	http://www.supp-103092.com/cat/sw/p1801.html
1803	SPNIX3.3 – DL	Operating System Software: SPNIX V3.3 – Additional developer license.	24	1	1	103092	orderable	60	51	http://www.supp-103092.com/cat/sw/p1803.html
1804	SPNIX3.3 – UL/N	Operating System Software: SPNIX V3.3 – Additional user license with network access.	24	1	1	103092	orderable	65	56	http://www.supp-103092.com/cat/sw/p1804.html
1805	SPNIX3.3 – UL/A	Operating System Software: SPNIX V3.3 – Additional user license class A.	24	1	1	103092	orderable	50	42	http://www.supp-103092.com/cat/sw/p1805.html
1806	SPNIX3.3 – UL/C	Operating System Software: SPNIX V3.3 – Additional user license class C.	24	1	1	103092	orderable	50	42	http://www.supp-103092.com/cat/sw/p1806.html
1808	SPNIX3.3 – UL/D	Operating System Software: SPNIX V3.3 – Additional user license class D.	24	1	1	103092	orderable	55	46	http://www.supp-103092.com/cat/sw/p1808.html
1820	SPNIX3.3 – NL	Operating System Software: SPNIX V3.3 – Additional network access license.	24	1	1	103092	orderable	55	45	http://www.supp-103092.com/cat/sw/p1820.html
1822	SPNIX4.0 – SL	Operating System Software: SPNIX V4.0 – Base Server License. Includes 10 general licenses for system administration, developers, or users. No network user licensing.	24	1	1	103092	orderable	1500	1303	http://www.supp-103092.com/cat/sw/p1822.html
2422	SPNIX4.0 – SAL	Operating System Software: SPNIX V4.0 – Additional system administrator license, including network access.	24	1	1	103092	orderable	150	130	http://www.supp-103092.com/cat/sw/p2422.html
2452	SPNIX4.0 – DL	Operating System Software: SPNIX V4.0 – Additional developer license.	24	1	1	103092	orderable	100	88	http://www.supp-103092.com/cat/sw/p2452.html
2462	SPNIX4.0 – UL/N	Operating System Software: SPNIX V4.0 – Additional user license with network access.	24	1	1	103092	orderable	80	71	http://www.supp-103092.com/cat/sw/p2462.html
2464	SPNIX4.0 – UL/A	Operating System Software: SPNIX V4.0 – Additional user license class A.	24	1	1	103092	orderable	70	62	http://www.supp-103092.com/cat/sw/p2464.html
2467	SPNIX4.0 – UL/D	Operating System Software: SPNIX V4.0 – Additional user license class D.	24	1	1	103092	orderable	80	64	http://www.supp-103092.com/cat/sw/p2467.html
2468	SPNIX4.0 – UL/C	Operating System Software: SPNIX V4.0 – Additional user license class C.	24	1	1	103092	orderable	75	67	http://www.supp-103092.com/cat/sw/p2468.html
2470	SPNIX4.0 – NL	Operating System Software: SPNIX V4.0 – Additional network access license.	24	1	1	103092	orderable	80	70	http://www.supp-103092.com/cat/sw/p2470.html
2471	SPNIX3.3 SU	Operating System Software: SPNIX V3.3 – Base Server License Upgrade to V4.0.	24	1	1	103092	orderable	500	439	http://www.supp-103092.com/cat/sw/p2471.html
2492	SPNIX3.3 AU	Operating System Software: SPNIX V3.3 – V4.0 upgrade; class A user.	24	1	1	103092	orderable	45	38	http://www.supp-103092.com/cat/sw/p2492.html
2493	SPNIX3.3 C/DU	Operating System Software: SPNIX V3.3 – V4.0 upgrade; class C or D user.	24	1	1	103092	orderable	25	22	http://www.supp-103092.com/cat/sw/p2493.html
2494	SPNIX3.3 NU	Operating System Software: SPNIX V3.3 – V4.0 upgrade; network access license.	24	1	1	103092	orderable	25	20	http://www.supp-103092.com/cat/sw/p2494.html
2995	SPNIX3.3 SAU	Operating System Software: SPNIX V3.3 – V4.0 upgrade; system administrator license.	24	1	1	103092	orderable	70	62	http://www.supp-103092.com/cat/sw/p2995.html
3290	SPNIX3.3 DU	Operating System Software: SPNIX V3.3 – V4.0 upgrade; developer license.	24	1	1	103092	orderable	65	55	http://www.supp-103092.com/cat/sw/p3290.html
1778	C for SPNIX3.3 – 1 Seat	C programming software for SPNIX V3.3 – single user	25	1	-6	103092	orderable	62	52	http://www.supp-103092.com/cat/sw/p1778.html
1779	C for SPNIX3.3 – Doc	C programming language documentation, SPNIX V3.3	25	2	10	103092	orderable	128	112	http://www.supp-103092.com/cat/sw/p1779.html
1780	C for SPNIX3.3 – Sys	C programming software for SPNIX V3.3 – system compiler, libraries, linker	25	1	-6	103092	orderable	450	385	http://www.supp-103092.com/cat/sw/p1780.html
2371	C for SPNIX4.0 – Doc	C programming language documentation, SPNIX V4.0	25	2	10	103092	orderable	146	119	http://www.supp-103092.com/cat/sw/p2371.html
2423	C for SPNIX4.0 – 1 Seat	C programming software for SPNIX V4.0 – single user	25	1	-6	103092	orderable	84	73	http://www.supp-103092.com/cat/sw/p2423.html
3501	C for SPNIX4.0 – Sys	C programming software for SPNIX V4.0 – system compiler, libraries, linker	25	1	-6	103092	orderable	555	448	http://www.supp-103092.com/cat/sw/p3501.html
3502	C for SPNIX3.3 -Sys/U	C programming software for SPNIX V3.3 – 4.0 Upgrade; system compiler, libraries, linker	25	1	-6	103092	orderable	105	88	http://www.supp-103092.com/cat/sw/p3502.html
3503	C for SPNIX3.3 – Seat/U	C programming software for SPNIX V3.3 – 4.0 Upgrade – single user	25	1	-6	103092	orderable	22	18	http://www.supp-103092.com/cat/sw/p3503.html
1774	Base ISO CP – BL	Base ISO Communication Package – Base License	29	1	0	103088	orderable	110	93	http://www.supp-103088.com/cat/sw/p1774.html
1775	Client ISO CP – S	ISO Communication Package add-on license for additional SPNIX V3.3 client.	29	1	0	103087	orderable	27	22	http://www.supp-103087.com/cat/sw/p1775.html
1794	OSI 8-16/IL	OSI Layer 8 to 16 – Incremental License	29	1	0	103096	orderable	128	112	http://www.supp-103096.com/cat/sw/p1794.html
1825	X25 – 1 Line License	X25 network access control system, single user	29	1	-6	103093	orderable	25	21	http://www.supp-103093.com/cat/sw/p1825.html
2004	IC Browser – S	IC Web Browser for SPNIX. Browser with network mail capability.	29	1	-1	103086	orderable	90	80	http://www.supp-103086.com/cat/sw/p2004.html
2005	IC Browser Doc – S	Documentation set for IC Web Browser for SPNIX. Includes Installation Manual, Mail Server Administration Guide, and User Quick Reference.	29	2	0	103086	orderable	115	100	http://www.supp-103086.com/cat/sw/p2005.html
2416	Client ISO CP – S	ISO Communication Package add-on license for additional SPNIX V4.0 client.	29	1	0	103088	orderable	41	36	http://www.supp-103088.com/cat/sw/p2416.html
2417	Client ISO CP – V	ISO Communication Package add-on license for additional Vision client.	29	1	0	103088	orderable	33	27	http://www.supp-103088.com/cat/sw/p2417.html
2449	OSI 1-4/IL	OSI Layer 1 to 4 – Incremental License	29	1	0	103088	orderable	83	72	http://www.supp-103088.com/cat/sw/p2449.html
3101	IC Browser – V	IC Web Browser for Vision with manual. Browser with network mail capability.	29	2	-1	103086	orderable	75	67	http://www.supp-103086.com/cat/sw/p3101.html
3170	Smart Suite – V/SP	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. Spanish language software and user manuals.	29	2	-6	103089	orderable	161	132	http://www.supp-103089.com/cat/sw/p3170.html
3171	Smart Suite – S3.3/EN	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX Version 3.3. English language software and user manuals.	29	2	-6	103089	orderable	148	120	http://www.supp-103089.com/cat/sw/p3171.html
3172	Graphics – DIK+	Software Kit Graphics: Draw-It Kwik-Plus. Includes extensive clip art files and advanced drawing tools for 3-D object manipulation, variable shading, and extended character fonts.	29	1	-1	103094	orderable	42	34	http://www.supp-103094.com/cat/sw/p3172.html
3173	Graphics – SA	Software Kit Graphics: SmartArt. Professional graphics package for SPNIX with multiple line styles, textures, built-in shapes and common symbols.	29	1	-1	103094	orderable	86	72	http://www.supp-103094.com/cat/sw/p3173.html
3175	Project Management – S4.0	Project Management Software, for SPNIX V4.0. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.	29	1	-1	103089	orderable	37	32	http://www.supp-103089.com/cat/sw/p3175.html
3176	Smart Suite – V/EN	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. English language software and user manuals.	29	2	-6	103089	orderable	120	103	http://www.supp-103089.com/cat/sw/p3176.html
3177	Smart Suite – V/FR	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. French language software and user manuals.	29	2	-6	103089	orderable	120	102	http://www.supp-103089.com/cat/sw/p3177.html
3245	Smart Suite – S4.0/FR	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. French language software and user manuals.	29	2	-6	103089	orderable	222	195	http://www.supp-103089.com/cat/sw/p3245.html
3246	Smart Suite – S4.0/SP	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. Spanish language software and user manuals.	29	2	-6	103089	orderable	222	193	http://www.supp-103089.com/cat/sw/p3246.html
3247	Smart Suite – V/DE	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for Vision. German language software and user manuals.	29	2	-6	103089	orderable	120	96	http://www.supp-103089.com/cat/sw/p3247.html
3248	Smart Suite – S4.0/DE	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. German language software and user manuals.	29	2	-6	103089	orderable	222	193	http://www.supp-103089.com/cat/sw/p3248.html
3250	Graphics – DIK	Software Kit Graphics: Draw-It Kwik. Simple graphics package for Vision systems, with options to save in GIF, JPG, and BMP formats.	29	1	-1	103083	orderable	28	24	http://www.supp-103083.com/cat/sw/p3250.html
3251	Project Management – V	Project Management Software, for Vision. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.	29	1	-1	103093	orderable	31	26	http://www.supp-103093.com/cat/sw/p3251.html
3252	Project Management – S3.3	Project Management Software, for SPNIX V3.3. Software includes command line and graphical interface with text, graphic, spreadsheet, and customizable report formats.	29	1	-1	103093	orderable	26	23	http://www.supp-103093.com/cat/sw/p3252.html
3253	Smart Suite – S4.0/EN	Office Suite (SmartWrite, SmartArt, SmartSpread, SmartBrowse) for SPNIX V4.0. English language software and user manuals.	29	2	-6	103089	orderable	222	188	http://www.supp-103089.com/cat/sw/p3253.html
3257	Web Browser – SB/S 2.1	Software Kit Web Browser: SmartBrowse V2.1 for SPNIX V3.3. Includes context sensitive help files and online documentation.	29	1	-1	103082	orderable	66	58	http://www.supp-103082.com/cat/sw/p3257.html
3258	Web Browser – SB/V 1.0	Software Kit Web Browser: SmartBrowse V2.1 for Vision. Includes context sensitive help files and online documentation.	29	1	-1	103082	orderable	80	70	http://www.supp-103082.com/cat/sw/p3258.html
3362	Web Browser – SB/S 4.0	Software Kit Web Browser: SmartBrowse V4.0 for SPNIX V4.0. Includes context sensitive help files and online documentation.	29	1	-1	103082	orderable	99	81	http://www.supp-103082.com/cat/sw/p3362.html
2231	Desk – S/V	Standard-sized desk; capitalizable, taxable item. Final finish is from veneer in stock at time of order, including oak, ash, cherry, and mahogany.	31	5	15	103082	orderable	2510	2114	http://www.supp-103082.com/cat/off/p2231.html
2335	Mobile phone	Dual band mobile phone with low battery consumption. Lightweight, foldable, with socket for single earphone and spare battery compartment.	31	1	-5	103088	orderable	100	83	http://www.supp-103088.com/cat/off/p2335.html
2350	Desk – W/48	Desk – 48 inch white laminate without return; capitalizable, taxable item.	31	5	20	103082	orderable	2500	2129	http://www.supp-103082.com/cat/off/p2350.html
2351	Desk – W/48/R	Desk – 60 inch white laminate with 48 inch return; capitalizable, taxable item.	31	5	20	103082	orderable	2900	2386	http://www.supp-103082.com/cat/off/p2351.html
2779	Desk – OS/O/F	Executive-style oversized oak desk with file drawers. Final finish is customizable when ordered, light or dark oak stain, or natural hand rubbed clear.	31	5	25	103082	orderable	3980	3347	http://www.supp-103082.com/cat/off/p2779.html
3337	Mobile Web Phone	Mobile phone including monthly fee for Web access. Slimline shape with leather-look carrying case and belt clip.	31	2	-5	103088	orderable	800	666	http://www.supp-103088.com/cat/off/p3337.html
2091	Paper Tablet LW 8 1/2 x 11	Paper tablet, lined, white, size 8 1/2 x 11 inch	32	1	0	103095	orderable	1	0	http://www.supp-103095.com/cat/off/p2091.html
2093	Pens – 10/FP	Permanent ink pen dries quickly and is smear resistant. Provides smooth, skip-free writing. Fine point. Single color boxes (black, blue, red) or assorted box (6 black, 3 blue, and 1 red).	32	1	0	103090	orderable	8	7	http://www.supp-103090.com/cat/off/p2093.html
2144	Card Organizer Cover	Replacement cover for desk top style business card holder. Smoke grey (original color) or clear plastic.	32	1	-1	103094	orderable	18	14	http://www.supp-103094.com/cat/off/p2144.html
2336	Business Cards Box – 250	Business cards box, capacity 250. Use form BC110-2, Rev. 3/2000 (hardcopy or online) when ordering and complete all fields marked with an asterisk.	32	1	0	103091	orderable	55	49	http://www.supp-103091.com/cat/off/p2336.html
2337	Business Cards – 1000/2L	Business cards box, capacity 1000, 2-sided with different language on each side. Use form BC111-2, Rev. 12/1999 (hardcopy or online) when ordering – complete all fields marked with an asterisk and check box for second language (English is always on side 1).	32	1	0	103091	orderable	300	246	http://www.supp-103091.com/cat/off/p2337.html
2339	Paper – Std Printer	20 lb. 8.5×11 inch white laser printer paper (recycled), ten 500-sheet reams	32	3	0	103095	orderable	25	21	http://www.supp-103095.com/cat/off/p2339.html
2536	Business Cards – 250/2L	Business cards box, capacity 250, 2-sided with different language on each side. Use form BC111-2, Rev. 12/1999 (hardcopy or online) when ordering – complete all fields marked with an asterisk and check box for second language (English is always on side 1).	32	1	0	103091	orderable	80	68	http://www.supp-103091.com/cat/off/p2536.html
2537	Business Cards Box – 1000	Business cards box, capacity 1000. Use form BC110-3, Rev. 3/2000 (hardcopy or online) when ordering and complete all fields marked with an asterisk.	32	1	0	103091	orderable	200	176	http://www.supp-103091.com/cat/off/p2537.html
2783	Clips – Paper	World brand paper clips set the standard for quality.10 boxes with 100 clips each. #1 regular or jumbo, smooth or non-skid.	32	2	0	103080	orderable	10	8	http://www.supp-103080.com/cat/off/p2783.html
2808	Paper Tablet LY 8 1/2 x 11	Paper Tablet, Lined, Yellow, size 8 1/2 x 11 inch	32	1	0	103098	orderable	1	0	http://www.supp-103098.com/cat/off/p2808.html

oe.categories_tab
Contains information related to each product category and the hierarchal relationship between product categories and their corresponding parent category, if applicable. There is one row per product category.

category_name	category_description	category_id	parent_category_id
hardware	computer hardware and peripherals	10	90
hardware1	monitors	11	10
hardware2	printers	12	10
hardware3	harddisks	13	10
hardware4	memory components/upgrades	14	10
hardware5	processors, sound and video cards, network cards, motherboards	15	10
hardware6	keyboards, mouses, mouse pads	16	10
hardware7	other peripherals (CD-ROM, DVD, tape cartridge drives, …)	17	10
hardware8	miscellaneous hardware (cables, screws, power supplies …)	19	10
software	computer software	20	90
software1	spreadsheet software	21	20
software2	word processing software	22	20
software3	database software	23	20
software4	operating systems	24	20
software5	software development tools (including languages)	25	20
software6	miscellaneous software	29	20
office equipment	office furniture and supplies	30	90
office1	capitalizable assets (desks, chairs, phones …)	31	30
office2	office supplies for daily use (pencils, erasers, staples, …)	32	30
office3	manuals, other books	33	30
office4	miscellaneous office supplies	39	30
online catalog	catalog of computer hardware, software, and office equipment	90	–

hr.employees
Contains information related to each employee and a hierarchal employee-manager relationship. There is one row per employee.

employee_id	first_name	last_name	email	phone_number	hire_date	job_id	salary	commission_pct	manager_id	department_id
100	Steven	King	SKING	515.123.4567	17-Jun-03	AD_PRES	24000	–	–	90
101	Neena	Kochhar	NKOCHHAR	515.123.4568	21-Sep-05	AD_VP	17000	–	100	90
102	Lex	De Haan	LDEHAAN	515.123.4569	13-Jan-01	AD_VP	17000	–	100	90
103	Alexander	Hunold	AHUNOLD	590.423.4567	3-Jan-06	IT_PROG	9000	–	102	60
104	Bruce	Ernst	BERNST	590.423.4568	21-May-07	IT_PROG	6000	–	103	60
105	David	Austin	DAUSTIN	590.423.4569	25-Jun-05	IT_PROG	4800	–	103	60
106	Valli	Pataballa	VPATABAL	590.423.4560	5-Feb-06	IT_PROG	4800	–	103	60
107	Diana	Lorentz	DLORENTZ	590.423.5567	7-Feb-07	IT_PROG	4200	–	103	60
108	Nancy	Greenberg	NGREENBE	515.124.4569	17-Aug-02	FI_MGR	12008	–	101	100
109	Daniel	Faviet	DFAVIET	515.124.4169	16-Aug-02	FI_ACCOUNT	9000	–	108	100
110	John	Chen	JCHEN	515.124.4269	28-Sep-05	FI_ACCOUNT	8200	–	108	100
111	Ismael	Sciarra	ISCIARRA	515.124.4369	30-Sep-05	FI_ACCOUNT	7700	–	108	100
112	Jose Manuel	Urman	JMURMAN	515.124.4469	7-Mar-06	FI_ACCOUNT	7800	–	108	100
113	Luis	Popp	LPOPP	515.124.4567	7-Dec-07	FI_ACCOUNT	6900	–	108	100
114	Den	Raphaely	DRAPHEAL	515.127.4561	7-Dec-02	PU_MAN	11000	–	100	30
115	Alexander	Khoo	AKHOO	515.127.4562	18-May-03	PU_CLERK	3100	–	114	30
116	Shelli	Baida	SBAIDA	515.127.4563	24-Dec-05	PU_CLERK	2900	–	114	30
117	Sigal	Tobias	STOBIAS	515.127.4564	24-Jul-05	PU_CLERK	2800	–	114	30
118	Guy	Himuro	GHIMURO	515.127.4565	15-Nov-06	PU_CLERK	2600	–	114	30
119	Karen	Colmenares	KCOLMENA	515.127.4566	10-Aug-07	PU_CLERK	2500	–	114	30
120	Matthew	Weiss	MWEISS	650.123.1234	18-Jul-04	ST_MAN	8000	–	100	50
121	Adam	Fripp	AFRIPP	650.123.2234	10-Apr-05	ST_MAN	8200	–	100	50
122	Payam	Kaufling	PKAUFLIN	650.123.3234	1-May-03	ST_MAN	7900	–	100	50
123	Shanta	Vollman	SVOLLMAN	650.123.4234	10-Oct-05	ST_MAN	6500	–	100	50
124	Kevin	Mourgos	KMOURGOS	650.123.5234	16-Nov-07	ST_MAN	5800	–	100	50
125	Julia	Nayer	JNAYER	650.124.1214	16-Jul-05	ST_CLERK	3200	–	120	50
126	Irene	Mikkilineni	IMIKKILI	650.124.1224	28-Sep-06	ST_CLERK	2700	–	120	50
127	James	Landry	JLANDRY	650.124.1334	14-Jan-07	ST_CLERK	2400	–	120	50
128	Steven	Markle	SMARKLE	650.124.1434	8-Mar-08	ST_CLERK	2200	–	120	50
129	Laura	Bissot	LBISSOT	650.124.5234	20-Aug-05	ST_CLERK	3300	–	121	50
130	Mozhe	Atkinson	MATKINSO	650.124.6234	30-Oct-05	ST_CLERK	2800	–	121	50
131	James	Marlow	JAMRLOW	650.124.7234	16-Feb-05	ST_CLERK	2500	–	121	50
132	TJ	Olson	TJOLSON	650.124.8234	10-Apr-07	ST_CLERK	2100	–	121	50
133	Jason	Mallin	JMALLIN	650.127.1934	14-Jun-04	ST_CLERK	3300	–	122	50
134	Michael	Rogers	MROGERS	650.127.1834	26-Aug-06	ST_CLERK	2900	–	122	50
135	Ki	Gee	KGEE	650.127.1734	12-Dec-07	ST_CLERK	2400	–	122	50
136	Hazel	Philtanker	HPHILTAN	650.127.1634	6-Feb-08	ST_CLERK	2200	–	122	50
137	Renske	Ladwig	RLADWIG	650.121.1234	14-Jul-03	ST_CLERK	3600	–	123	50
138	Stephen	Stiles	SSTILES	650.121.2034	26-Oct-05	ST_CLERK	3200	–	123	50
139	John	Seo	JSEO	650.121.2019	12-Feb-06	ST_CLERK	2700	–	123	50
140	Joshua	Patel	JPATEL	650.121.1834	6-Apr-06	ST_CLERK	2500	–	123	50
141	Trenna	Rajs	TRAJS	650.121.8009	17-Oct-03	ST_CLERK	3500	–	124	50
142	Curtis	Davies	CDAVIES	650.121.2994	29-Jan-05	ST_CLERK	3100	–	124	50
143	Randall	Matos	RMATOS	650.121.2874	15-Mar-06	ST_CLERK	2600	–	124	50
144	Peter	Vargas	PVARGAS	650.121.2004	9-Jul-06	ST_CLERK	2500	–	124	50
145	John	Russell	JRUSSEL	011.44.1344.429268	1-Oct-04	SA_MAN	14000	0.4	100	80
146	Karen	Partners	KPARTNER	011.44.1344.467268	5-Jan-05	SA_MAN	13500	0.3	100	80
147	Alberto	Errazuriz	AERRAZUR	011.44.1344.429278	10-Mar-05	SA_MAN	12000	0.3	100	80
148	Gerald	Cambrault	GCAMBRAU	011.44.1344.619268	15-Oct-07	SA_MAN	11000	0.3	100	80
149	Eleni	Zlotkey	EZLOTKEY	011.44.1344.429018	29-Jan-08	SA_MAN	10500	0.2	100	80
150	Peter	Tucker	PTUCKER	011.44.1344.129268	30-Jan-05	SA_REP	10000	0.3	145	80
151	David	Bernstein	DBERNSTE	011.44.1344.345268	24-Mar-05	SA_REP	9500	0.25	145	80
152	Peter	Hall	PHALL	011.44.1344.478968	20-Aug-05	SA_REP	9000	0.25	145	80
153	Christopher	Olsen	COLSEN	011.44.1344.498718	30-Mar-06	SA_REP	8000	0.2	145	80
154	Nanette	Cambrault	NCAMBRAU	011.44.1344.987668	9-Dec-06	SA_REP	7500	0.2	145	80
155	Oliver	Tuvault	OTUVAULT	011.44.1344.486508	23-Nov-07	SA_REP	7000	0.15	145	80
156	Janette	King	JKING	011.44.1345.429268	30-Jan-04	SA_REP	10000	0.35	146	80
157	Patrick	Sully	PSULLY	011.44.1345.929268	4-Mar-04	SA_REP	9500	0.35	146	80
158	Allan	McEwen	AMCEWEN	011.44.1345.829268	1-Aug-04	SA_REP	9000	0.35	146	80
159	Lindsey	Smith	LSMITH	011.44.1345.729268	10-Mar-05	SA_REP	8000	0.3	146	80
160	Louise	Doran	LDORAN	011.44.1345.629268	15-Dec-05	SA_REP	7500	0.3	146	80
161	Sarath	Sewall	SSEWALL	011.44.1345.529268	3-Nov-06	SA_REP	7000	0.25	146	80
162	Clara	Vishney	CVISHNEY	011.44.1346.129268	11-Nov-05	SA_REP	10500	0.25	147	80
163	Danielle	Greene	DGREENE	011.44.1346.229268	19-Mar-07	SA_REP	9500	0.15	147	80
164	Mattea	Marvins	MMARVINS	011.44.1346.329268	24-Jan-08	SA_REP	7200	0.1	147	80
165	David	Lee	DLEE	011.44.1346.529268	23-Feb-08	SA_REP	6800	0.1	147	80
166	Sundar	Ande	SANDE	011.44.1346.629268	24-Mar-08	SA_REP	6400	0.1	147	80
167	Amit	Banda	ABANDA	011.44.1346.729268	21-Apr-08	SA_REP	6200	0.1	147	80
168	Lisa	Ozer	LOZER	011.44.1343.929268	11-Mar-05	SA_REP	11500	0.25	148	80
169	Harrison	Bloom	HBLOOM	011.44.1343.829268	23-Mar-06	SA_REP	10000	0.2	148	80
170	Tayler	Fox	TFOX	011.44.1343.729268	24-Jan-06	SA_REP	9600	0.2	148	80
171	William	Smith	WSMITH	011.44.1343.629268	23-Feb-07	SA_REP	7400	0.15	148	80
172	Elizabeth	Bates	EBATES	011.44.1343.529268	24-Mar-07	SA_REP	7300	0.15	148	80
173	Sundita	Kumar	SKUMAR	011.44.1343.329268	21-Apr-08	SA_REP	6100	0.1	148	80
174	Ellen	Abel	EABEL	011.44.1644.429267	11-May-04	SA_REP	11000	0.3	149	80
175	Alyssa	Hutton	AHUTTON	011.44.1644.429266	19-Mar-05	SA_REP	8800	0.25	149	80
176	Jonathon	Taylor	JTAYLOR	011.44.1644.429265	24-Mar-06	SA_REP	8600	0.2	149	80
177	Jack	Livingston	JLIVINGS	011.44.1644.429264	23-Apr-06	SA_REP	8400	0.2	149	80
178	Kimberely	Grant	KGRANT	011.44.1644.429263	24-May-07	SA_REP	7000	0.15	149	–
179	Charles	Johnson	CJOHNSON	011.44.1644.429262	4-Jan-08	SA_REP	6200	0.1	149	80
180	Winston	Taylor	WTAYLOR	650.507.9876	24-Jan-06	SH_CLERK	3200	–	120	50
181	Jean	Fleaur	JFLEAUR	650.507.9877	23-Feb-06	SH_CLERK	3100	–	120	50
182	Martha	Sullivan	MSULLIVA	650.507.9878	21-Jun-07	SH_CLERK	2500	–	120	50
183	Girard	Geoni	GGEONI	650.507.9879	3-Feb-08	SH_CLERK	2800	–	120	50
184	Nandita	Sarchand	NSARCHAN	650.509.1876	27-Jan-04	SH_CLERK	4200	–	121	50
185	Alexis	Bull	ABULL	650.509.2876	20-Feb-05	SH_CLERK	4100	–	121	50
186	Julia	Dellinger	JDELLING	650.509.3876	24-Jun-06	SH_CLERK	3400	–	121	50
187	Anthony	Cabrio	ACABRIO	650.509.4876	7-Feb-07	SH_CLERK	3000	–	121	50
188	Kelly	Chung	KCHUNG	650.505.1876	14-Jun-05	SH_CLERK	3800	–	122	50
189	Jennifer	Dilly	JDILLY	650.505.2876	13-Aug-05	SH_CLERK	3600	–	122	50
190	Timothy	Gates	TGATES	650.505.3876	11-Jul-06	SH_CLERK	2900	–	122	50
191	Randall	Perkins	RPERKINS	650.505.4876	19-Dec-07	SH_CLERK	2500	–	122	50
192	Sarah	Bell	SBELL	650.501.1876	4-Feb-04	SH_CLERK	4000	–	123	50
193	Britney	Everett	BEVERETT	650.501.2876	3-Mar-05	SH_CLERK	3900	–	123	50
194	Samuel	McCain	SMCCAIN	650.501.3876	1-Jul-06	SH_CLERK	3200	–	123	50
195	Vance	Jones	VJONES	650.501.4876	17-Mar-07	SH_CLERK	2800	–	123	50
196	Alana	Walsh	AWALSH	650.507.9811	24-Apr-06	SH_CLERK	3100	–	124	50
197	Kevin	Feeney	KFEENEY	650.507.9822	23-May-06	SH_CLERK	3000	–	124	50
198	Donald	OConnell	DOCONNEL	650.507.9833	21-Jun-07	SH_CLERK	2600	–	124	50
199	Douglas	Grant	DGRANT	650.507.9844	13-Jan-08	SH_CLERK	2600	–	124	50
200	Jennifer	Whalen	JWHALEN	515.123.4444	17-Sep-03	AD_ASST	4400	–	101	10
201	Michael	Hartstein	MHARTSTE	515.123.5555	17-Feb-04	MK_MAN	13000	–	100	20
202	Pat	Fay	PFAY	603.123.6666	17-Aug-05	MK_REP	6000	–	201	20
203	Susan	Mavris	SMAVRIS	515.123.7777	7-Jun-02	HR_REP	6500	–	101	40
204	Hermann	Baer	HBAER	515.123.8888	7-Jun-02	PR_REP	10000	–	101	70
205	Shelley	Higgins	SHIGGINS	515.123.8080	7-Jun-02	AC_MGR	12008	–	101	110
206	William	Gietz	WGIETZ	515.123.8181	7-Jun-02	AC_ACCOUNT	8300	–	205	110

hr.jobs
Contains information related to each job. It’s possible for a job to exist without being assigned to any employee. There is one row per job.

job_id	job_title	min_salary	max_salary
AD_PRES	President	20080	40000
AD_VP	Administration Vice President	15000	30000
AD_ASST	Administration Assistant	3000	6000
FI_MGR	Finance Manager	8200	16000
FI_ACCOUNT	Accountant	4200	9000
AC_MGR	Accounting Manager	8200	16000
AC_ACCOUNT	Public Accountant	4200	9000
SA_MAN	Sales Manager	10000	20080
SA_REP	Sales Representative	6000	12008
PU_MAN	Purchasing Manager	8000	15000
PU_CLERK	Purchasing Clerk	2500	5500
ST_MAN	Stock Manager	5500	8500
ST_CLERK	Stock Clerk	2008	5000
SH_CLERK	Shipping Clerk	2500	5500
IT_PROG	Programmer	4000	10000
MK_MAN	Marketing Manager	9000	15000
MK_REP	Marketing Representative	4000	9000
HR_REP	Human Resources Representative	4000	9000
PR_REP	Public Relations Representative	4500	10500

Real-world Examples
When solving multi-step problems, there is often a need to reference the output of a subproblem or intermediate result set and/or to bring data at different levels of detail together. Subqueries in the FROM clause are a great solution to these types of problems. A subquery in the FROM clause is often referred to as a derived table or an inline view. I’ll refer to subqueries in the FROM clause as derived tables going forward. Additionally, most SQL dialects require derived tables to be named. The requirement is sensible because the contents of the derived table resulting from the query populating it can be referenced in the outer query and may require fully-qualifying the attribute or column name with the schema and table name.

Explore the following two real-world examples to obtain a better understanding on how this type of subquery can be used.

Top Selling Product by Product Category
Consider the task of generating a report containing information for the top selling product, in terms of quantity sold, for each product category. In the report, the necessary information is the category name, product name, and the total quantity ordered for the specific product. In the query below, a subquery has been used in the FROM clause to determine the rank of each product in terms of quantity sold within each category. This derived table’s contents are then referenced in the outer query and filtered to those products with a quantity rank value of 1 (i.e., the top selling product within each product category). In this case, there is one row per distinct product category; however, in instances of ties within a product category, there will be as many rows as there are products within the category having the same total quantity value. If you’re unfamiliar with the DENSE_RANK function, then consider checking out my DENSE_RANK page for a detailed explanation and additional examples.

category_name	product_name	total_quantity
hardware6	KB 101/EN	1861
hardware8	Screws <B.28.S>	1036
hardware1	Monitor Hinge – HD	994
office4	Plastic Stock – Y	942
office3	Manual – Vision Net6.3/US	918
office2	Card Holder – 25	887
hardware2	LaserPro 600/6/BW	741
hardware5	Video Card /E32	673
office1	Desk – W/48	394
software6	Smart Suite – V/EN	307
hardware7	Modem – 56/H/E	215
software2	Word Processing – SWP/V 4.5	192
hardware3	HD 8GB /I	123
software4	SPNIX4.0 – UL/N	82
hardware4	DIMM – 32MB	47
software5	C for SPNIX4.0 – Sys	46
software1	Spreadsheet – SSS/V 2.0	18

I’d be remiss if I didn’t reiterate why a subquery is used here as opposed to a single SELECT statement. Due to the order in which the clauses are processed, the quantity rank attribute derived in the SELECT clause of the subquery can’t be referenced (i.e., used) in the same SELECT statement to filter to the top selling product(s) in each product category. Because the WHERE clause is processed prior to the SELECT clause, the subquery’s contents are treated as an intermediate result set and filtered by the outer query referencing it.

In the example above, a subquery was used to handle the ranking of products within each product category. Subsequently, the results were referenced in the outer query and filtered to the top selling product in each product category.

In the next example, a subquery in the FROM clause is used to bring data at different levels of detail together for the comparison purposes.

Above, Equal to, or Below Average Salary?
Comparisons require the proper context to be meaningful. In this example, the task is to generate a report comparing each employee’s salary to the average salary of those employees within the same job role. An apples-to-apples comparison, roughly.

In the query below, the outer query returns one row per employee and the derived table, job_salary, returns one row per job ID. See the result set following the query for clarity. Keep in mind some relational database management systems do not require the derived table (i.e., job_salary) to be named; however, consider it a best practice and a requirement when the columns derived in the subquery need to be referenced in the outer query.

employee_id	job_id	salary	average_salary	difference
103	IT_PROG	9000	5760	3240
168	SA_REP	11500	8350	3150
174	SA_REP	11000	8350	2650
162	SA_REP	10500	8350	2150
145	SA_MAN	14000	12200	1800
150	SA_REP	10000	8350	1650
156	SA_REP	10000	8350	1650
169	SA_REP	10000	8350	1650
146	SA_MAN	13500	12200	1300
170	SA_REP	9600	8350	1250
163	SA_REP	9500	8350	1150
157	SA_REP	9500	8350	1150
151	SA_REP	9500	8350	1150
109	FI_ACCOUNT	9000	7920	1080
184	SH_CLERK	4200	3215	985
121	ST_MAN	8200	7280	920
185	SH_CLERK	4100	3215	885
137	ST_CLERK	3600	2785	815
192	SH_CLERK	4000	3215	785
120	ST_MAN	8000	7280	720
141	ST_CLERK	3500	2785	715
193	SH_CLERK	3900	3215	685
152	SA_REP	9000	8350	650
158	SA_REP	9000	8350	650
122	ST_MAN	7900	7280	620
188	SH_CLERK	3800	3215	585
129	ST_CLERK	3300	2785	515
133	ST_CLERK	3300	2785	515
175	SA_REP	8800	8350	450
125	ST_CLERK	3200	2785	415
138	ST_CLERK	3200	2785	415
189	SH_CLERK	3600	3215	385
115	PU_CLERK	3100	2780	320
142	ST_CLERK	3100	2785	315
110	FI_ACCOUNT	8200	7920	280
176	SA_REP	8600	8350	250
104	IT_PROG	6000	5760	240
186	SH_CLERK	3400	3215	185
116	PU_CLERK	2900	2780	120
134	ST_CLERK	2900	2785	115
177	SA_REP	8400	8350	50
117	PU_CLERK	2800	2780	20
130	ST_CLERK	2800	2785	15
100	AD_PRES	24000	24000	0
101	AD_VP	17000	17000	0
102	AD_VP	17000	17000	0
108	FI_MGR	12008	12008	0
114	PU_MAN	11000	11000	0
200	AD_ASST	4400	4400	0
201	MK_MAN	13000	13000	0
202	MK_REP	6000	6000	0
203	HR_REP	6500	6500	0
204	PR_REP	10000	10000	0
205	AC_MGR	12008	12008	0
206	AC_ACCOUNT	8300	8300	0
180	SH_CLERK	3200	3215	-15
194	SH_CLERK	3200	3215	-15
126	ST_CLERK	2700	2785	-85
139	ST_CLERK	2700	2785	-85
196	SH_CLERK	3100	3215	-115
181	SH_CLERK	3100	3215	-115
112	FI_ACCOUNT	7800	7920	-120
118	PU_CLERK	2600	2780	-180
143	ST_CLERK	2600	2785	-185
147	SA_MAN	12000	12200	-200
187	SH_CLERK	3000	3215	-215
197	SH_CLERK	3000	3215	-215
111	FI_ACCOUNT	7700	7920	-220
119	PU_CLERK	2500	2780	-280
131	ST_CLERK	2500	2785	-285
144	ST_CLERK	2500	2785	-285
140	ST_CLERK	2500	2785	-285
190	SH_CLERK	2900	3215	-315
153	SA_REP	8000	8350	-350
159	SA_REP	8000	8350	-350
127	ST_CLERK	2400	2785	-385
135	ST_CLERK	2400	2785	-385
183	SH_CLERK	2800	3215	-415
195	SH_CLERK	2800	3215	-415
128	ST_CLERK	2200	2785	-585
136	ST_CLERK	2200	2785	-585
198	SH_CLERK	2600	3215	-615
199	SH_CLERK	2600	3215	-615
132	ST_CLERK	2100	2785	-685
182	SH_CLERK	2500	3215	-715
191	SH_CLERK	2500	3215	-715
123	ST_MAN	6500	7280	-780
160	SA_REP	7500	8350	-850
154	SA_REP	7500	8350	-850
171	SA_REP	7400	8350	-950
105	IT_PROG	4800	5760	-960
106	IT_PROG	4800	5760	-960
113	FI_ACCOUNT	6900	7920	-1020
172	SA_REP	7300	8350	-1050
164	SA_REP	7200	8350	-1150
148	SA_MAN	11000	12200	-1200
178	SA_REP	7000	8350	-1350
161	SA_REP	7000	8350	-1350
155	SA_REP	7000	8350	-1350
124	ST_MAN	5800	7280	-1480
165	SA_REP	6800	8350	-1550
107	IT_PROG	4200	5760	-1560
149	SA_MAN	10500	12200	-1700
166	SA_REP	6400	8350	-1950
179	SA_REP	6200	8350	-2150
167	SA_REP	6200	8350	-2150
173	SA_REP	6100	8350	-2250

Knowledge Check
If you’d like to confirm your understanding on the use of subqueries in the FROM clause and other fundamental concepts, consider solving a handful of my practice problems here.