Short Answer:
On the survey table there are two fields: object_type and object_id.
For a Request, Incident, or Problem; the object type will be 'cr' and the ticket id (not ref_num) will be the object_id.
If all you want is the survey id and name for a specific call_req ticket then the SQL is:
SELECT SVY.id "Survey ID", SVY.sym "Survey Name", CR.ref_num "Ticket RefNum"
FROM survey SVY
LEFT JOIN call_req CR ON SVY.object_id = CR.id
Sample Results:
Survey ID Survey Name Ticket RefNum
400001 CustSat 238
More details:
Check out the relationship diagram here:
Computer Associates International, Inc. Table List
J.W.