Re: Impossible join?

2005-07-18 Thread Dawid Kuroczko
On 7/16/05, Jonathan Mangin <[EMAIL PROTECTED]> wrote: > Hello all, > > I'm storing data from a series of tests throughout each > 24-hour period. I thought to create a table for each test. > (There are six tests, lots more cols per test, and many > users performing each test.) > > select test1.d

RE: Impossible join?

2005-07-18 Thread Gordon Bruce
nt: Monday, July 18, 2005 8:03 AM To: Michael Stassen Cc: mysql@lists.mysql.com Subject: Re: Impossible join? > Jonathan Mangin wrote: > >> Hello all, >> >> I'm storing data from a series of tests throughout each >> 24-hour period. I thought to create a table

Re: Impossible join?

2005-07-18 Thread Jonathan Mangin
Jonathan Mangin wrote: Hello all, I'm storing data from a series of tests throughout each 24-hour period. I thought to create a table for each test. (There are six tests, lots more cols per test, and many users performing each test.) But each test is performed no more than once per day by

Re: Impossible join?

2005-07-16 Thread Michael Stassen
Jonathan Mangin wrote: Hello all, I'm storing data from a series of tests throughout each 24-hour period. I thought to create a table for each test. (There are six tests, lots more cols per test, and many users performing each test.) But each test is performed no more than once per day by a

Impossible join?

2005-07-16 Thread Jonathan Mangin
Hello all, I'm storing data from a series of tests throughout each 24-hour period. I thought to create a table for each test. (There are six tests, lots more cols per test, and many users performing each test.) select test1.date, test1.time, test2.date, test2.time from test1 left join test2 on