SELECT categories.categoryid, categories.categoryname, products.productname, products.quantityperunit, products.unitprice, products.unitsinstock 
FROM categories, products 
WHERE categories.categoryid = products.categoryid 
ORDER BY categories.categoryname

1	Beverages	Chai	10 boxes x 20 bags	18.0000	39
1	Beverages	Chang	24 - 12 oz bottles	19.0000	17
1	Beverages	Guaraná Fantástica	12 - 355 ml cans	4.5000	20
1	Beverages	Sasquatch Ale	24 - 12 oz bottles	14.0000	111
1	Beverages	Steeleye Stout	24 - 12 oz bottles	18.0000	20
1	Beverages	Côte de Blaye	12 - 75 cl bottles	263.5000	17
1	Beverages	Chartreuse verte	750 cc per bottle	18.0000	69
1	Beverages	Ipoh Coffee	16 - 500 g tins	46.0000	17
1	Beverages	Laughing Lumberjack Lager	24 - 12 oz bottles	14.0000	52
1	Beverages	Outback Lager	24 - 355 ml bottles	15.0000	15
1	Beverages	Rhönbräu Klosterbier	24 - 0.5 l bottles	7.7500	125
1	Beverages	Lakkalikööri	500 ml	18.0000	57
1	Beverages	teste	5	.0000	0
2	Condiments	Aniseed Syrup	12 - 550 ml bottles	10.0000	13
2	Condiments	Chef Anton's Cajun Seasoning	48 - 6 oz jars	22.0000	53
2	Condiments	Chef Anton's Gumbo Mix	36 boxes	21.3500	0
2	Condiments	Grandma's Boysenberry Spread	12 - 8 oz jars	25.0000	120
2	Condiments	Northwoods Cranberry Sauce	12 - 12 oz jars	40.0000	6
2	Condiments	Genen Shouyu	24 - 250 ml bottles	15.5000	39
2	Condiments	Gula Malacca	20 - 2 kg bags	19.4500	27
2	Condiments	Sirop d'érable	24 - 500 ml bottles	28.5000	113
2	Condiments	Vegie-spread	15 - 625 g jars	43.9000	24
2	Condiments	Louisiana Fiery Hot Pepper Sauce	32 - 8 oz bottles	21.0500	76
2	Condiments	Louisiana Hot Spiced Okra	24 - 8 oz jars	17.0000	4
2	Condiments	Original Frankfurter grüne Soße	12 boxes	13.0000	32
3	Confections	Pavlova	32 - 500 g boxes	17.4500	29
3	Confections	Teatime Chocolate Biscuits	10 boxes x 12 pieces	9.2000	25
3	Confections	Sir Rodney's Marmalade	30 gift boxes	81.0000	40
3	Confections	Sir Rodney's Scones	24 pkgs. x 4 pieces	10.0000	3
3	Confections	NuNuCa Nuß-Nougat-Creme	20 - 450 g glasses	14.0000	76
3	Confections	Gumbär Gummibärchen	100 - 250 g bags	31.2300	15
3	Confections	Schoggi Schokolade	100 - 100 g pieces	43.9000	49
3	Confections	Zaanse koeken	10 - 4 oz boxes	9.5000	36
3	Confections	Chocolade	10 pkgs.	12.7500	15
3	Confections	Maxilaku	24 - 50 g pkgs.	20.0000	10
3	Confections	Valkoinen suklaa	12 - 100 g bars	16.2500	65
3	Confections	Tarte au sucre	48 pies	49.3000	17
3	Confections	Scottish Longbreads	10 boxes x 8 pieces	12.5000	6
4	Dairy Products	Queso Cabrales	1 kg pkg.	21.0000	22
4	Dairy Products	Queso Manchego La Pastora	10 - 500 g pkgs.	38.0000	86
4	Dairy Products	Gorgonzola Telino	12 - 100 g pkgs	12.5000	0
4	Dairy Products	Mascarpone Fabioli	24 - 200 g pkgs.	32.0000	9
4	Dairy Products	Geitost	500 g	2.5000	112
4	Dairy Products	Raclette Courdavault	5 kg pkg.	55.0000	79
4	Dairy Products	Camembert Pierrot	15 - 300 g rounds	34.0000	19
4	Dairy Products	Gudbrandsdalsost	10 kg pkg.	36.0000	26
4	Dairy Products	Flotemysost	10 - 500 g pkgs.	21.5000	26
4	Dairy Products	Mozzarella di Giovanni	24 - 200 g pkgs.	34.8000	14
5	Grains/Cereals	Gustaf's Knäckebröd	24 - 500 g pkgs.	21.0000	104
5	Grains/Cereals	Tunnbröd	12 - 250 g pkgs.	9.0000	61
5	Grains/Cereals	Singaporean Hokkien Fried Mee	32 - 1 kg pkgs.	14.0000	26
5	Grains/Cereals	Filo Mix	16 - 2 kg boxes	7.0000	38
5	Grains/Cereals	Gnocchi di nonna Alice	24 - 250 g pkgs.	38.0000	21
5	Grains/Cereals	Ravioli Angelo	24 - 250 g pkgs.	19.5000	36
5	Grains/Cereals	Wimmers gute Semmelknödel	20 bags x 4 pieces	33.2500	22
5	Grains/Cereals	Produto (teste)	12	100.0000	500
6	Meat/Poultry	Mishi Kobe Niku	18 - 500 g pkgs.	97.0000	29
6	Meat/Poultry	Alice Mutton	20 - 1 kg tins	39.0000	0
6	Meat/Poultry	Thüringer Rostbratwurst	50 bags x 30 sausgs.	123.7900	0
6	Meat/Poultry	Perth Pasties	48 pieces	32.8000	0
6	Meat/Poultry	Tourtière	16 pies	7.4500	21
6	Meat/Poultry	Pâté chinois	24 boxes x 2 pies	24.0000	115
7	Produce	Uncle Bob's Organic Dried Pears	12 - 1 lb pkgs.	30.0000	15
7	Produce	Tofu	40 - 100 g pkgs.	23.2500	35
7	Produce	Rössle Sauerkraut	25 - 825 g cans	45.6000	26
7	Produce	Manjimup Dried Apples	50 - 300 g pkgs.	53.0000	20
7	Produce	Longlife Tofu	5 kg pkg.	10.0000	4
8	Seafood	Ikura	12 - 200 ml jars	31.0000	31
8	Seafood	Konbu	2 kg box	6.0000	24
8	Seafood	Carnarvon Tigers	16 kg pkg.	62.5000	42
8	Seafood	Nord-Ost Matjeshering	10 - 200 g glasses	25.8900	10
8	Seafood	Inlagd Sill	24 - 250 g  jars	19.0000	112
8	Seafood	Gravad lax	12 - 500 g pkgs.	26.0000	11
8	Seafood	Boston Crab Meat	24 - 4 oz tins	18.4000	123
8	Seafood	Jack's New England Clam Chowder	12 - 12 oz cans	9.6500	85
8	Seafood	Rogede sild	1k pkg.	9.5000	5
8	Seafood	Spegesild	4 - 450 g glasses	12.0000	95
8	Seafood	Escargots de Bourgogne	24 pieces	13.2500	62
8	Seafood	Röd Kaviar	24 - 150 g jars	15.0000	101