var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: query help please
I have data as follows in a table called TNR_RESP
RESP_ID | TYP_ID | CXL_RESP_ID
123 | 1 | ABC
ABC | 0 |
If i pass RESP_ID = 123 to the query, i wanted to see RESP_ID, TYP_ID, CXL_RESP_ID and TYP_ID of CXL_RESP_ID
Here ABC is reference of another RESP_ID in the same table
I want to see the result as follows
123 1 ABC 0
How do we get the result?
I appreciate your help.
Last edited by manth; 12-08-04 at 20:03.
This is one way of doing...
SELECT A.RESP_ID, A.TYP_ID, A.CXL_RESP_ID, B.TYP_ID
FROM TNR_RESP A, TNR_RESP B