Error: ORA-01427:single-row subquery returns more than 1 row?

[kishorer]

QUERY->

 select *
  from sttb_record_log
 where table_name IN ('STTMS_CUSTOMER', 'STTM_CUSTOMER')
   AND KEY_ID LIKE(SELECT '%' || CUSTOMER_NO || '%'
                      FROM STTM_CUSTOMER
                    )

Error-ora-01427:single-row subquery returns more than one row

[Rabbit]

Please use code tags when posting code.

When using the like operator with a subquery, the subquery must only return one row.