If A=B & B=C, need a query which says A=C
Hi All,
My requirement is something like: I have a table with two Columns:
COLA COLB
A B
B C
Now i need to analyse these records and understand that If A=B & B=C, then I need to insert the third record in the table like below:
A C
I was trying Hierarchical queries, but unable to reach the requirement. Any help is much appreciated.
Thanks in Advance,
Ram Mohan T