Unable to extract data from three tables simultaneously

There are four tables in the database: User, Tags, Information, and Developer.

The Information table includes a column called “Tags,” which is a list of tags filled by the user. It also has another column called “User,” which represents the type of user.

The Developer table has a column named “Tags,” which is uploaded by the admin. Additionally, there is a column named “Developer Name.”

The task at hand is to compose an email to the users, which will include a list of developer names who have matching tags in both the Information table and the Developer table.

I am able to get the matching tags using intersection but not able to fetch the developer name, and am able to get the developer name through repeating group but am not able to send these developer list in email.

This topic was automatically closed after 70 days. New replies are no longer allowed.