Hi all...
I got this small problem...
which it's taking time..

I have this tables:

ESC_SUPP
(PK = SUPP_CODE)
SUPP_CODE GSL_CODE
S1 110
S2 110
S4 111
S5 111

ESC_SUP_PART
(PK = SUPP_CODE, PART)
SUPP_CODE PART
S1 A1
S2 A1
S4 A1
S5 A1

Then, when I submit this query:

select b.part, a.gsl_code , count(1)
from esc_supp a,
esc_sup_part b
where a.supp_code = b.supp_code
and b.part = 'A1'
group by a.gsl_code, b.part

result:

PART GSL_CODE COUNT(1)
A1 110 2
A1 111 2

Goal: I need to get Only One row, any
of the above, since I will put the query inside a PL/SQL code.


How can do this without using
subqueries?

I hope you can help me...
Thanks in adcance!
JC.