| 3 Table date in one report [message #399457] |
Wed, 22 April 2009 05:43  |
shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi
|
Senior Member |
|
|
Hellow All,
I create 3 Tables
CREATE TABLE item (
Item_date DATE,
item_no NUMBER(10),
item_name VARCHAR2(40),
rate NUMBER(10,2),
quantity NUMBER(20),
trans_item VARCHAR2(10),
catagory_no NUMBER(10),
CONSTRAINT pk_item_no PRIMARY KEY ( item_no ))
2nd table is purchase
CREATE TABLE purchase (
purchase_date DATE,
item_no_pur NUMBER(20),
item_name_pur VARCHAR2(40),
challan_no NUMBER(10),
supplier_id_pur NUMBER(10),
supplier_name_pur VARCHAR2(40),
quantity NUMBER(10,2),
rate NUMBER(10,2),
amount NUMBER(10,2),
trans_pur VARCHAR2(10),
CONSTRAINT fk_purchase_item_no FOREIGN KEY ( item_no_pur ) references item(item_no))
3rd table is Sale
CREATE TABLE sale (
sale_date DATE,
item_no_sale NUMBER(20),
item_name_sale VARCHAR2(40),
challan_no NUMBER(10),
customer_id_sale NUMBER(10),
customer_name_sale VARCHAR2(40),
quantity NUMBER(10,2),
rate NUMBER(10,2),
amount NUMBER(10,2),
trans_sale VARCHAR2(10),
CONSTRAINT fk_sale_item_no FOREIGN KEY ( item_no_sale ) references item(item_no))
Now i want a report which will show 1st date wise item record
then
date wise purchase record and then
date wise sale report
in one report its required item wise
Hope you guys understand
Thanks
shahzaib ismail
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
