PHPLens
Category Product Supplier QuantityPerUnit Stock Price 1 Confections Zaanse koeken Zaanse Snoepfabriek 10 - 4 oz boxes 36 9.50 2 Grains/Cereals Wimmers gute Semmelknödel Plutzer Lebensmittelgroßmärkte AG 20 bags x 4 pieces 22 33.25 3 Condiments Vegie-spread Pavlova, Ltd. 15 - 625 g jars 24 43.90 4 Confections Valkoinen suklaa Karkki Oy 12 - 100 g bars 65 16.25 5 Produce Uncle Bob's Organic Dried Pears Grandma Kelly's Homestead 12 - 1 lb pkgs. 15 30.00		ProductID 47 Product Zaanse koeken Supplier Zaanse Snoepfabriek Category Confections QuantityPerUnit 10 - 4 oz boxes Price 9.50 Stock 36 UnitsOnOrder 0 ReorderLevel 0 Discontinued 0 Notes   OrderDate
PHPLens (Page 1)

Notes

• CATEGORYID is a lookup based on select categoryid,categoryname from categories.
• SUPPLIERID is a lookup using select supplierid,companyname from suppliers.