On Tue, Mar 2, 2010 at 7:36 AM, Rich Shepard <[email protected]> wrote: > On Tue, 2 Mar 2010, Patrick J. Timlick wrote: > >> select m.close, a.close, g.close, i.close from msft m, aapl a, goog g, >> intc i where date = "$date" and time = "$time" >> >> I don't think this works because date and time are ambiguous; they could be >> from any of the 4 tables. > > Yup. > > If the date and time are the same in all four tables you'd need a WHERE > clause that relates them all: > > WHERE a.date == g.date == i.date == m.date AND ... for the times. > > You can also do sub-selects from the tables. > > Rich > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug >
I was sure I was missing something like that regarding date.time. Drew- _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
