Hi,
I have 2 tables namely Cont_Dtls and Node_Dtls
The structure of Cont_Dtls is as follows:
Cont_ID FName Address
BCF01 Sajit XYZ
BCF02 ABC MNO
BCF03 EFG XXX
The structure of Node_Dtls is as follows
Cont_ID Node_ID Parent_ID
BCF01 52 50
BCF02 53 52
BCF03 54 51
So what is want from an SQL is if the user selects the Node_ID = 52 the corresponding Cont_ID details would be displayed. Now, if the same Node_ID is present in the Parent_ID then the details of that record would also be displayed. So this query should display the records of BCF01 and BCF02.
Hope i am able to explain it properly...help would be highly appreciated.
Thanking you all in advance
Sajit