Hi, All

I have following SQL, which I want to return all the clients record
even its country id or salsrep id is null, but it didn't give me
what I want even I do have records in the clients, and also even I
create all the indexes against all ID fields for all tables, but
under plan, it still use NATURAL against all the tables, Please tell
me what am I doing wrong?

SELECT CLIENTS.*,
COUNTRY.NAME AS COUNTRYNAME,
SALESREP.NAME AS SALESMAN,
CREDITSTATUS.DESCRIPTION,
CREDITSTATUS."LEVEL" FROM CLIENTS
RIGHT JOIN COUNTRY ON COUNTRY.ID = CLIENTS.COUNTRY_ID
RIGHT JOIN SALESREP ON SALESREP.ID = CLIENTS.SALEREP_ID
RIGHT JOIN CREDITSTATUS ON CREDITSTATUS.ID =
CLIENTS.CREDITSTATUS_ID

Thanks

William