|
|
|
|
| Re: Field replacement [message #665904 is a reply to message #665901] |
Sat, 30 September 2017 05:26  |
 |
Littlefoot
Messages: 21654
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?
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
