Your SQL statement has GROUP BY ProductID. That will only show one row for each unique product ID. If you change it to GROUP BY ProductID, LubeTypeID, that will show unique rows when either field is unique.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.