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
