List:General Discussion« Previous MessageNext Message »
From:Haidar Pesebe Date:December 16 2012 6:59am
Subject:Re: call up the sales
View as plain text  
I mean table B (sale of books) is TABLE C (sale of book). Sorry.
Sales reports on a monthly basis each publisher.
thanks for the help.

2012/12/16 Haidar Pesebe <haidarpesebe@stripped>

> Dear All,
>
> I am asking for help to solve my problem to call the sale of books.
>
> There are 3 tables which each like this:
>
>
> TABLE A (Publisher)
> -------------------------------
> ID  :  NAME     : EMAIL :
> -------------------------------
> 1     : ABC     :   abc@abc
> 2     : CDE     :   cde@cde
> -------------------------------
>
> TABLE B (BOOKS TABLE)
> -------------------------------------------------------------------
> : IDBOOK : TITLE         : PUBLISHER ID : ISBN
> -------------------------------------------------------------------
> : 1    : TITLE 01        : 1       :  001
> : 2    : TITLE 02        : 1   :  002
> : 3    : TITLE 03        : 2       :  003
> : 4    : TITLE 04        : 2       :  004
> -----------------------------------------------------------------
>
> TABLE B (SALE OF BOOKS)
>
> --------------------------------------------------------------------------------
> : ID : ISBN      : QTY   : DATE : LOCATION
>
> --------------------------------------------------------------------------------
> : 1    : 001        :  20     :  2012-12-01 :
> : 2    : 001        :  11     :  2012-12-01 :
> : 3    : 002        :  15     :  2012-12-01 :
> : 4    : 003        :  10     :  2012-12-01 :
> : 5    : 003        :  7      :  2012-12-01 :
> : 6    : 003        :  8      :  2012-12-01 :
> : 7    : 004        :  10     :  2012-12-01 :
> ---------------------------------------------------------------
>
> How do I call up the sales in December 2012 for ABC Publisher or call the
> sale in 2012 for ABC publisher?
>
> Thanks and regards,
> Haidarpesebe
>

Thread
call up the salesHaidar Pesebe16 Dec
  • Re: call up the salesHaidar Pesebe16 Dec
RE: call up the salesMartin Gainty16 Dec
  • Re: call up the salesHaidar Pesebe17 Dec