query error

[oracle_coorg]

hi
in my excels iam using the external source
With ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DRIVER={Microsoft ODBC for Oracle};UID=scott;PWD=tiger;SERVER=dev;" _
, Destination:=Range("A1"))
.CommandText = Array( _
"SELECT TELE.CALLING_DATE, TELE.CALLING_TIME, TELE.CALLED_NUMBER, TELE.DURATION, TELE.UNITS" & Chr(13) & "" & Chr(10)
& "FROM SCOTT.TELE TELE" _
-----
but i unable excute this query
SELECT TELE.CALLED_NUMBER, sum(TELE.DURATION) DURATION, sum(TELE.UNITS) UNITS
FROM SCOTT.TELE TELE
group by TELE.CALLED_NUMBER
order by DURATION,UNITS
error :: from caluse

[oracle_coorg]

"SELECT TELE.CALLED_NUMBER, sum(TELE.DURATION) , sum(TELE.UNITS)
&"FROM SCOTT.TELE TELE "
"group by TELE.CALLED_NUMBER"
"order by DURATION,UNITS"

[RichardSchollar]

Hi

I presume the first one didn't work because you used a conflicting alias (not sure about this, but seems reasonable). Perhaps try:


"SELECT TELE.CALLED_NUMBER, sum(TELE.DURATION) aggDURATION, sum(TELE.UNITS) aggUNITS " & _
"FROM SCOTT.TELE TELE " & _
"group by TELE.CALLED_NUMBER " & _
"order by aggDURATION,aggUNITS"

Richard

[oracle_coorg]

hi
Richard thts grate
it worked fine
a real one ......