Try OUTER JOIN.
FROM WORKORDER,LOCATIONS
WHERE WORKORDER.LOCATION(+)=LOCATIONS.LOCATION
Are you getting an error here?
Tamil
|
Results 1 to 3 of 3
Thread: Count Query with Months and YearThreaded View
|
Click Here to Expand Forum to Full Width |