Infrastructure Software

First step can you describe TABLE1 and TABLE2?

I already edit the question

Describe means like this

SQL> desc emp
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMPNO                                     NOT NULL NUMBER
 ENAME                                              VARCHAR2(6)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER
 HIREDATE                                           DATE
 SAL                                                NUMBER
 COM                                                NUMBER
 DEPTNO                                             NUMBER

SQL> desc dept
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DEPTNO                                    NOT NULL NUMBER
 DNAME                                              VARCHAR2(10)
 LOC                                                VARCHAR2(8)

SQL>

I posted the desc of table

>  and c.status like 'ANSWERED%'

I dont see STATUS column in Table2

sorry i accidentally erase, now there's a status table

Ok got it, Change this

select 'Data'
       ||','||to_char(d.dtime_day,'MM/dd/yyyy')
       ||','||sg1_cnt

To

select 'Data'
       ||','||dtime_day 
       ||','||sg1_cnt

dtime_day is already converted in the inner query.

i changed it already but i got zero results only, which is not right. each item have large total of result

> i changed it already

Should I use my crystal ball to find it out?

> but i got zero results only, which is not right. each item have large total of result

Without your data i cant do much.

select 'Data'
||','||to_char(d.dtime_day,'MM/dd/yyyy')
||','||sg1_cnt
||','||sg2_cnt
||','||sg3_cnt
||','||sg4_cnt
||','||sg5_cnt
||','||sg6_cnt
||','||sg7_cnt
||','||sg8_cnt
||','||sg9_cnt
||','||sg10_cnt

In the above select statement, which tables contains the columns (sg1_cnt, sg2_cnt, sg3_cnt.....etc), I think by removing these columns from SELECT shall fix the issue.

Those come from the PIVOT. That is fine.

i change the sql script, but i got still zero results

33795304-702b-48ff-b4ba-e896b1db94db wrote:

i change the sql script, but i got still zero results

That means some of your conditions are failing. As said already without knowing what's in the table cant help. Just check you join and where conditions.

Just to be clear, are you asking us to tell you why a query we haven't seen returns no rows based on data we haven't seen?

I just posted some data of each table coumn

I already edited my post - sql sript and added more info about table columns