This content has been marked as final. Show 2 replies
I have the following problem:
In a table with web data, containing different type of IDs. Each of the rows has only one of these IDs. Example:
I also have a Users table which contain a master UserID + the other IDs for that particular user. Example
Users (the IDs in red match the IDs from the WebData table):
What I want to achieve is add the MasterID in the WebData. It would be easy (for me at least) to join it if there was only 1 webID which I would need to match with the MasterID, but I'm struggeling to get this done.
So basically, I would need to end up with this:
What would be the best approach to achieve this?