Skip to content
Advertisement

Joining two tables on multiple values of the joining column

I am stuck in situation where I am unable to make any progress. The requirement is below.

I have two tables one is ContentTag

This contains the linking between Content table and tag table

and there is foldettag table which contains the linking between folder table and tag table

the folder will contain only those contents which are linked to all the tags which are liked to the folder.

Note: I need the result whihc contains the link of those contentId and FolderId which are linked to exactly same tags.

for example it will contain the following result

Can someone plz suggest to me some approach which I should follow to proceed with this?

I am trying to find a solution for the past few hours but unable to find any solution Thank you

Advertisement

Answer

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement