0

`select s.sname as stationname , sum(di.quantity) as quantity from demand_information di, demand d, company c , station s where s.sno = d.sno(+) and di.demandno = d.demandno and d.cno = c.cno and c.cname = $P{companyname} and to_char(d.demanddate,'MM-yyyy') = $P{gdate} and di.pno = (select pno from products where productname = $P{productname}) group by s.sname'

Following is my query ... i want to print all the stations , so i am using s,sno =+ d.sno ( left outer join) on station but nothing is working right... Please give it a view. Thank you.

Edited by Majestics

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by Perry31
0

Hi majesctics,
can u desc your tables so that it will be useful to know the column names and do proper query?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.