Column CAMPAIGN_POST_ID, which is documented in the table IRC_CAMP_ASSETS_B not present when queried
Summary:
I am attempting to establish a join between the tables IRC_CAMP_ASSETS_B and IRC_SOURCE_TRACKING using the column CAMPAIGN_POST_ID. While the column CAMPAIGN_POST_ID is present in IRC_SOURCE_TRACKING and listed in the foreign key relationships in the documentation for IRC_CAMP_ASSETS_B, it is not available in the actual IRC_CAMP_ASSETS_B table when queried.
This discrepancy is causing issues with the intended join operation and raises questions about the accuracy of the documentation in relation to the table structure. Clarification or resolution of this issue is required to ensure proper functionality and data integrity when working with these tables.