Start a new topic
Answered

How do I get the golden data for a given source id?

How do I get the golden data for a given source id?


Best Answer

Getting the golden data for a given source record ID:

SELECT M.B_SOURCEID, G.<attribute_list>  FROM MD_<entity> M INNER JOIN GD_<entity> G ON   (    G.<primary_key> = M.<primary_key> ) WHERE     M.B_PUBID = '<publisher_code>'   AND     M.B_SOURCEID = '<searched_sou


1 Comment

Answer

Getting the golden data for a given source record ID:

SELECT M.B_SOURCEID, G.<attribute_list>  FROM MD_<entity> M INNER JOIN GD_<entity> G ON   (    G.<primary_key> = M.<primary_key> ) WHERE     M.B_PUBID = '<publisher_code>'   AND     M.B_SOURCEID = '<searched_sou


Login to post a comment