From: Haidar Pesebe Date: December 18 2012 8:52am Subject: sales data every publisher List-Archive: http://lists.mysql.com/mysql/228827 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d0401f99d5f01e204d11c9f9f --f46d0401f99d5f01e204d11c9f9f Content-Type: text/plain; charset=ISO-8859-1 Hi all-- There are 3 tables which each like this: NOTE: The linkage between table A and table B is ID and IDPUBLISHER, while Table B to C is the ISBN. Sometimes there are some titles that are not sold in a given month. 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 C (SALES OF BOOKS) ---------------------------------------------- : IDSALES : ISBN : PRICE : QTY : DATE : ----------------------------------------------- : 1 : 001 : 100 : 20 : 2012-12-01 : : 2 : 001 : 100 : 11 : 2012-12-01 : : 3 : 002 : 60 : 15 : 2012-12-01 : : 4 : 003 : 30 : 10 : 2012-12-01 : : 5 : 003 : 30 : 7 : 2012-12-01 : : 6 : 003 : 30 : 8 : 2012-12-01 : : 7 : 004 : 50 : 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? RESULT OF Sales Books of ABC Publisher in December 2012 --------------------------------------- No. : Books Title : ISBN :QTY : AMOUNT --------------------------------------- 1. : Title 01 : 001 : 31 : 3,100 2. : Tile 02 : 002 : 15 : 900 .... and so on ......... --------------------------------------- help me to solve this problem Thanks --f46d0401f99d5f01e204d11c9f9f--