| Field replacement [message #665900] |
Fri, 29 September 2017 07:29  |
kekanap
Messages: 19
Registered: January 2008
Location: Centurion
|
Junior Member |
|
|
Hallo Team
I have 2tables subd_detail and si_service_identity.
Both tables can be joined by subd_msisdn/si_msisdn AND subd_si_uid/si_uid.
si_service_indentity is the master meaning si_msisdn will have a matching si_uid. My question is how can i correct subd_msisdn/subd_su_uid combination to match what is in si_service_identity.
I hope it makes sense. Any ideas?
Regards
|
|
|
|
|
|
| Re: Field replacement [message #665904 is a reply to message #665901] |
Sat, 30 September 2017 05:26  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
As SI_SERVICE_IDENTITY is a master, it means that SUBD_DETAIL's columns are set as foreign key which reference SI_SERVICE_IDENTITY columns.
If I understood you correctly, a query looks like
select *
from subd_detail d, si_service_identity i
where d.subd_msisdn = i.si_msisdn
and d.subd_si_uid = i.si_uid
If that's so, what do you mean by "correct subd_msisdn/subd_su_uid combination to match what is in si_service_identity"? These are foreign key columns, how/why would you "correct" them? They are used to maintain connection between those two tables so - either they match (so you can join tables) or they don't (so you can't join them).
Or, I don't understand what you are saying so - please, could you explain it once again?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
