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 :
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
Dec 18
Peter Brawley Re: sales data every publisher
Dec 18, 2012; 13:29
Peter Brawley
Re: sales data every publisher
Dec 18
Shawn Green Re: sales data every publisher
Dec 18, 2012; 14:43
Shawn Green
Re: sales data every publisher
Dec 19
Haidar Pesebe Re: sales data every publisher
Dec 19, 2012; 15:20
Haidar Pesebe
Re: sales data every publisher
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!