From: Haidar Pesebe Date: December 16 2012 6:59am Subject: Re: call up the sales List-Archive: http://lists.mysql.com/mysql/228820 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=14dae93409a9ff6c2d04d0f2cf39 --14dae93409a9ff6c2d04d0f2cf39 Content-Type: text/plain; charset=ISO-8859-1 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 > 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 > --14dae93409a9ff6c2d04d0f2cf39--