IT Final Milestone

it_200_database.accdb

Home >Computer Science homework help >IT Final Milestone

Manufacturer Name	Street Address	City	State	Zip Code
Aspen Clothes	7922 Honey Horse Freeway	Los Angeles	CA	90006
Blue Manufacturers	4096 Lost Rabbit Mountain	Bakersfield	CA	93385
Bruno Apparel	3744 Sleepy Ridge	Ventura	CA	93003
Dusting Shoes	1046 Dusty Rise	Bronx	NY	10470
GQ Shirts	5543 Pleasant Road	Alameda	CA	94501
Skies The Limit	5633 High Creek Square	Brooklyn	NY	11201
Spirit Clothes	4660 Colonial Concession	Las Vegas	NV	89161
SW Stores	7757 Lazy Gate Point	Fresno	CA	93728
Wholesale Threads	780 Little Shadow Wood	San Francisco	CA	94105
Zen Clothes	8693 Tawny Plaza	Brooklyn	NY	11228

Clothing Item	Color	Manufacturer Name	Wholesale Price	Retail Price
Flip Flops	Tan	Dusting Shoes	¤ 15.00	25
Men's Button Shirt	Gray	GQ Shirts	¤ 13.00	55
Men's Fidora	Black	Zen Clothes	¤ 17.50	52
Men's Jeans	Jean	Wholesale Threads	¤ 21.00	90
Men's Slacks	Blue	Blue Manufacturers	¤ 20.00	65
Men's Tank	Orange	Aspen Clothes	¤ 11.50	23.5
Polo	Red	Spirit Clothes	¤ 15.00	52.5
Silk Blouse	Cream	Sky's the Limit	¤ 27.00	81
Sneakers	Maroon	Dusting Shoes	¤ 16.00	60
The GQ Shirt	Red	GQ Shirts	¤ 22.00	79
Women's Cardigan	Purple	Zen Clothes	¤ 23.00	72.5
Women's Jeans	Jean	Blue Manufacturers	¤ 22.50	75
Women's Shorts	Jean	Sky's The Limit	¤ 20.00	50
Women's Sneakers	Purple	Dusting Shoes	¤ 22.00	60
Women's Tank	Pink	Bruno Apparel	¤ 12.50	25.5
Women's T-Shirt	White	SW Stores	¤ 14.00	22.5
Yoga Pants	Black	Wholesale Threads	¤ 18.90	45

Retail Store Name	Street Address	City	State	Zip Code
Blue Threads	6734 Easy Vista St.	Austin	TX	78641
Elden Clothing	1529 Sleepy Nook Rd.	Boulder	CO	80302
Legacy Clothing	5571 Blue View Rd.	Aspen	CO	81611
Men's Apparel	2098 Misty Pines Rd.	Miami	FL	33133
Reynolds Jeans	857 Rustic Alley Blvd.	Seattle	WA	98103
Shoes For You	2786 Little St.	San Diego	CA	91915
Simplicity Apparel	1382 Clear Creek By-pass	Charleston	SC	29401
Sky Clothing	5764 Velvet Valley Rd.	Los Angeles	CA	90002
Timber Boutique	4982 Little Green St.	Flagstaff	AZ	86005
Women's Apparel	2352 Heather Blvd.	Atlanta	GA	30305

SELECT [Retail Stores].[Retail Store Name], [Retail Stores].State, [Clothing Manufacturers].[Manufacturer Name], [Retail Stores].[Clothing Item], [Clothing Products].[Retail Price] FROM ([Clothing Manufacturers] INNER JOIN [Clothing Products] ON [Clothing Manufacturers].[Manufacturer Name] = [Clothing Products].[Manufacturer Name]) INNER JOIN [Retail Stores] ON [Clothing Products].[Clothing Item] = [Retail Stores].[Clothing Item] ORDER BY [Retail Stores].[Retail Store Name];