Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find record with criteria, Tips required
Message
From
06/04/2005 23:40:44
 
 
To
All
General information
Forum:
Sybase
Category:
SQL Syntax
Title:
Find record with criteria, Tips required
Miscellaneous
Thread ID:
01002147
Message ID:
01002147
Views:
56
I have 2 tables named "Dialed" and "CustomerPhoneNo"

In "Dialed" contained:
Dialno
66978901*10123
5123113129*1#124*3
43189211#101*13*2*

In CustomerPhoneNo contained:
Rec no. customerphone customername
1 431892 Albert
2 4308080 Simon
3 5123113 Tommy
4 53908012 Ben
5 5908122 Bill
6 6189022 Ronnie
7 64288878 Susan
8 66978901 Albert

Based on "DialNo" field in "Dialed" table how to get the customername in CustomerPhoneNo table?

ie.
I want to get "Tommy" from CustomerPhoneNo table by using "5123113129*1#124*3" ..

please advise, how to deal with this? thanks a lot in advance

Regards
Winanjaya
Next
Reply
Map
View

Click here to load this message in the networking platform