PHPLens
Category Product Supplier QuantityPerUnit Stock Price 1 Beverages Changie Grandma Kelly's Homestead 24 - 12 oz bottles 17 0.00 2 Dairy Products Geitost Norske Meierier 500 g 112 2.50 3 Beverages Guaraná Fantástica Refrescos Americanas LTDA 12 - 355 ml cans 20 4.50 4 Seafood Konbu Mayumi's 2 kg box 24 6.00 5 Grains/Cereals Filo Mix G'day, Mate 16 - 2 kg boxes 38 7.00		ProductID 2 Product Changie Supplier Grandma Kelly's Homestead Category Beverages QuantityPerUnit 24 - 12 oz bottles Price 0.00 Stock 17 UnitsOnOrder 40 ReorderLevel 25 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.