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

Start a new topic

Answered

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

Stéphanie FOURRIER

started a topic over 4 years ago

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

Best Answer

Stéphanie FOURRIER said over 4 years ago

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

Stéphanie FOURRIER

said over 4 years ago

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