Record not retrived

Hi All,

Trying to write a join comparing a name column but the record is not retrieved. the NAme length is same. Not seeing any special characters.

CREATE TABLE TABLE1

NAME VARCHAR2(200);

INSERT INTO TABLE1

(NAME)

VALUES

('Ex Habriya (ferssdannd) GmaH');

INSERT INTO TABLE2

(NAME)

VALUES

('Ex Habriya (ferssdannd) GmaH');

Select A.NAME

FROM

TABLE1 A,TABLE2 B

WHERE A.NAME=B.NAME;

Please suggest how this can be fixed. I have other records with Strings which are retrieved fine. Not sure if it is due to "(" in the string.