2 tables[ scan_dates ] - date - marketUS[ scan_thresholds ] - date - symbolOther fields have been ignored ...The objective would be to create a 2 column return ...column 1 = symbolcolumn 2 = scoreQuery 1 : SELECT date FROM scan_dates WHERE marketUS = 1 ORDER BY dates ASC LIMIT 1,15;Query 2 : i want to query the table scan_thresholds with a date > 15 days ago ( well, with a date which is a result of Query 1 ) ... then for each combination of symbol and date ... compute a score, a score per symbol ...symbol += 2 ^ [row number of the date returned in query 1] ...