Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find record with criteria, Tips required
Message
De
06/04/2005 23:40:44
 
 
À
Tous
Information générale
Forum:
Sybase
Catégorie:
Syntaxe SQL
Titre:
Find record with criteria, Tips required
Divers
Thread ID:
01002147
Message ID:
01002147
Vues:
59
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform