Re: [sqlite] Multitable query question

2008-05-28 Thread beejayzed
Stephen Oberholtzer wrote: > > On Wed, May 28, 2008 at 11:15 PM, beejayzed <[EMAIL PROTECTED]> wrote: > >> >> I have two tables, one which has each visit(call) on a house logged, >> another >> which has each letter sent to a house logged. >> I would

[sqlite] Multitable query question

2008-05-28 Thread beejayzed
I have two tables, one which has each visit(call) on a house logged, another which has each letter sent to a house logged. I would like to create a query which has two columns, Letters.Date and Calls.Date, for a specific HouseID. I have tried this query for HouseID 16: Select Letters.Date,Calls.D