help me in retrieving the value

[blast]

Hi,

thanks for my first post...this is my problem
i have two tables a, b
i wanted to compare the value frm a with b but the probs is the table doesnt repesent the full value in b

eg....table a has value sav
able b has value savyyy

i need to pull this savyyyy frm b table but i dont want to like this
select col_tablea, col_tableb from tablea, tableb where
col_tablea like col_tableb%

this doesnt work i know its wrong without usng
select col_tablea, col_tableb from tablea, tableb where
col_tablea like sav% (i wanted to specify the colname instaead of the word, is it possible)

help me please

[iburyak]

Is it one to one relationship?

[aaryan]

select col_a,col_b from savvy,savvy1 where savvy1.col_b like savvy.col_a + '%'

[blast]

hi ,

thanks a in tons, it really worked......... ....it was too helpful
thanks once again