Re: [sqlite] Select from Select

On Sun, 19 Oct 2003, Brian Pugh wrote: > How many records in a certain Postcode area (Zip code to our > US friends!); > How many of those have telephones (ie, the field is blank if > they don't have a telephone); > How many with telephones can be canvassed (I have a field called > Canvass that

[sqlite] Select from Select

Hi, I would like to be able to run a query on my names and addresses database, returning the following: How many records in a certain Postcode area (Zip code to our US friends!); How many of those have telephones (ie, the field is blank if they don't have a telephone); How many with telephones