Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Count?
Try
select t1.field1, count(*)
from table_1 t1,
table_2 t2
where t2.field15 like '%'||t1.field1||'%'
group by t.field1
Received on Mon May 17 1999 - 14:05:01 CDT
![]() |
![]() |