PHPLens
Category Product Supplier QuantityPerUnit Stock Price 1 0 Grandma's Boysenberry Spread Grandma Kelly's Homestead 12 - 8 oz jars 150 25.00 2 Beverages Rhönbräu Klosterbier Plutzer Lebensmittelgroßmärkte AG 24 - 0.5 l bottles 125 7.75 3 Seafood Boston Crab Meat New England Seafood Cannery 24 - 4 oz tins 123 18.40 4 Meat/Poultry Pâté chinois Ma Maison 24 boxes x 2 pies 115 24.00 5 Condiments Sirop d'érable Forêts d'érables 24 - 500 ml bottles 113 28.50		ProductID 6 Product Grandma's Boysenberry Spread Supplier Grandma Kelly's Homestead Category 0 QuantityPerUnit 12 - 8 oz jars Price 25.00 Stock 150 UnitsOnOrder 0 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.