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