//trdopt rows > 100,000 //instropt rows > 100,000 //exchopt rows = 10; SELECT trddata.date, instr.sym, instr.under, instr.exp, exch.name, trddata.prc FROM trdopt trddata JOIN instropt instr ON trddata.optid = instr.id JOIN exchopt exch ON trddata.exchcode = exch.id WHERE DATE_FORMAT(trddata.date, '%Y-%m-%d %T') = '2013-04-02';
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)