Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
Dim Recordset1 Dim Recordset1_numRows set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_luxurygifts2_STRING Recordset1.Source = "SELECT a.id, a.updatedatetime, a.productid, a.site, a.price, b.deliverycost, SUM(a.price + b.deliverycost) as totalprice FROM priceinfo a inner join deliverycost b on a.site=b.site AND a.productid=b.productid WHERE a.id IN(SELECT MAX(id) FROM priceinfo WHERE productid ='12345678' group by site) group by a.site,a.id,a.updatedatetime, a.productid, a.price, b.deliverycost ORDER BY SUM(a.price + b.deliverycost) asc" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open Recordset1_numRows = 0
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.