RE: [sqlite] complex query question

2004-09-30 Thread Downey, Shawn
] Subject: Re: [sqlite] complex query question - Original Message - From: "Downey, Shawn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 7:26 PM Subject: [sqlite] complex query question > The query should return exactly 3 record

Re: [sqlite] complex query question

2004-09-30 Thread Lawrence Chitty
- Original Message - From: "Downey, Shawn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 7:26 PM Subject: [sqlite] complex query question > The query should return exactly 3 records: > > Hoyhoy | 2 | 1 | 1 > Fred

[sqlite] complex query question

2004-09-30 Thread Downey, Shawn
Hello all, First let me say thank you very much for a very useful mailing list. I have a somewhat complex SQL query question. Given the table: CREATE TABLE times(name CHAR(32) not null, time1 CHAR(10), time2 CHAR(10),