On 03/02/10 13:13, Tim Garton wrote: [snip] > select m.`date`, m.`time`, m.`close`, g.`close`, a.`close`, i.`close` > from msft m > join goog g on g.`date` = m.`date` and g.`time` = m.`time` > join aapl a on a.`date` = m.`date` and a.`time` = m.`time` > join intc i on i.`date` = m.`date` and i.`time` = m.`time` > where m.`date` between '2010-02-28' and '2010-03-02' >
Tim, you nailed it. You're query worked flawlessly. Have a look: date time close close close close 2009-01-05 09:14:00 20.2 319.49 93.62 15.05 2009-01-05 09:26:00 20.15 320 93.28 15.07 2009-01-05 09:28:00 20.19 320 93.16 15.08 That's just good information. Moreover, I've started asking myself, "why does this work," and from other responses, "what really is the deal with UNIONs and JOINs?" I am now also thinking of the steps necessary to re-engineer my database based on Tim's suggestion. Carlos, Konstanski, too, offered a few "fleshed out" solutions--you can tell he know what he's doing and gave me pause for thought. I'm impressed with the way you guys "locked on" to the problem and ran with it. Thanks very much to all of you for your insightful answers, suggestions, and references I can turn to for more information. I am grateful as late last night (early this morning?) it appeared as I was looking at having to climb a mountain. If you guys want a prediction for next week's MSFT stock, let me know. ;) Very Truly Yours, Cooper Stevenson -- ph: 541.971.0366 em: coo...@cooper.stevenson.name <mailto:coo...@cooper.stevenson.name> www: http://cooper.stevenson.name _______________________________________________ PLUG mailing list PLUG@lists.pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug