How to get the value [message #378889] |
Fri, 02 January 2009 05:02  |
SUMISHA
Messages: 2 Registered: October 2007 Location: CHENNAI
|
Junior Member |
|
|
Hi all,
I need a help to fetch the column.Let me brief out..I have two table with one column link but the values in two columns are different.
table 1:
col 1 :
values = 001
table 2:
col 1 :
values = '001','002','003'
Now i need check that the column value 001 of table 1 is there is cloumn 1 of table 2 ..
I have tried with substr and instr functions but i couldn't..can any one help me..
|
|
|
Re: How to get the value [message #378891 is a reply to message #378889] |
Fri, 02 January 2009 05:12   |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Welcome to the forum.
Why don't you post what you have tried so far and I am sure somebody will help you. In the mean time search for "varying in-list" in this forum and also spend some time reading the forum guidelines.
Regards
Raj
|
|
|
|