subject:"\[sqlite\] Another SELECT\/JOIN Question."

Re: [sqlite] Another SELECT/JOIN Question.

2009-10-30 Thread Igor Tandetnik

Peter Haworth wrote: > Trying to implement the following situation involving 4 tables > > Customers is the "master table" in that the results should end up with > one row for each primary key value in it. > > I need to sum the values of a column in the Sales table,

[sqlite] Another SELECT/JOIN Question.

2009-10-30 Thread Peter Haworth

Trying to implement the following situation involving 4 tables Customers is the "master table" in that the results should end up with one row for each primary key value in it. I need to sum the values of a column in the Sales table, which has a column that joins to the primary key of