Re: [GENERAL] Method of building views

2005-02-21 Thread Bruno Wolff III
On Sat, Feb 19, 2005 at 13:30:49 -, Richard Crawley <[EMAIL PROTECTED]> wrote: > > I suppose what I'm doing is building some quite large, complicated views. > Now, thus far I haven't had much choice, and the temp tables do help > debugging. But this approach doesn't allow the dbase any opt

[GENERAL] Method of building views

2005-02-20 Thread Richard Crawley
Hello everyone. I am a recent convert from quite an old version of MySQL. I have an ancient business app/database that I dump into MySQL overnight, then run a whole set of queries on to form tables that users then query using Excel DSN. Up to now, because MySQL didn't have subqueries, these routi