-
sqlplus matching
Hi Friends,
I have table EMP with column empname and another
LOANS_TABLE with column fullname.
EMP
======
EMPNAME
-----------
TOM WELLING
SCOTT WILSON
LOANS_TABLE
===========
FULLNAME
------------
WELLING, TOM
I want to list/match the employees with loans, eventhough lastname is
entered first in the loans table. In this case TOM WELLING is same
as WELLING, TOM
Can you help me please...
Thanks a lot
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|