RE: call up the sales

2012-12-16 Thread Martin Gainty
We are unable to solve your problem unless you can display 1)all Foreign Key relationships indicating how one Table-column can access Primary key of another table2)It is impossible to aggregate PriceOfBook information thru SUM or any other aggregator function(s) since PriceOfBook column is

Re: call up the sales

2012-12-16 Thread Haidar Pesebe
Thanks Mr. Martin. I forgot to include the price column in table C. The linkage between table A and table B is ID and IDPUBLISHER, while Table B to C is the ISBN. Also sometimes there are some titles that are not sold in a given month. TABLE A (Publisher) --- ID :