PHPLens
Category Product Supplier QuantityPerUnit Stock Price 1 Beverages Côte de Blaye Aux joyeux ecclésiastiques 12 - 75 cl bottles 17 263.50 2 Meat/Poultry Thüringer Rostbratwurst Plutzer Lebensmittelgroßmärkte AG 50 bags x 30 sausgs. 0 123.79 3 Meat/Poultry Mishi Kobe Niku Tokyo Traders 18 - 500 g pkgs. 29 97.00 4 Confections Sir Rodney's Marmalade Specialty Biscuits, Ltd. 30 gift boxes 40 81.00 5 Seafood Carnarvon Tigers Pavlova, Ltd. 16 kg pkg. 42 62.50		ProductID 38 Product Côte de Blaye Supplier Aux joyeux ecclésiastiques Category Beverages QuantityPerUnit 12 - 75 cl bottles Price 263.50 Stock 17 UnitsOnOrder 0 ReorderLevel 15 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.