General information
Title:
Find record with criteria, Tips required
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only