ORDER:Order_ID,Seed_ID,quantity(here orderid and seedid are composite primary key and one order may contain requests of multiple seeds by the same requester)
ORDER_LINE:Order_ID,Req_ID,Date of order,no.of seeds
Now i have to show all this information on a single report.
I am using ireport and i m new to this tool.The query i have made is like this:
Expand|Select|Wrap|Line Numbers
- Select orders.Order_ID AS "Order_ID",orders.quantity AS "quantity",orders.Seed_ID AS "Seed_ID",order_line.R_ID AS "R_ID",order_line.Date_order AS "date",order_line.no_of_seeds AS "no. of seeds",requesters.R_NAME AS "Req" from orders,order_line,requesters where orders.Order_ID=order_line.Order_ID AND order_line.R_ID=requesters.R_ID;