Check Records by name

[Geek_Guest]

Hi,

Imagine there are 2 tables

student

sno name course
1 john C
2 james Cpp
3 Tim john Java
4 scott C
.
.
.

Studfee

sno name fee
101 James 3000
102 John 5000
103 franklyn 6000

Q. I want check the records whose names are matching(look like) with student table.
Eg. The name John in studfee is matching with Tim John and John of student table..

Please help me out in finding this
if possible mail the answer to [mail id removed]

Thanks in advance.
Rama.

Question asked by visitor Rama.

[debasisdas]

join both the tables on Like condition.