Suppose i have 3 profiles in profile table made in acs , i have created cardianality link with another table name as product having fields email , product id and product name .
now if each email id has 3 products corresponding to them then how will we show it in query that we want to show a particular email id and its corresponding products that is linked with profile table. ?
If I understand correctly your question, you should be able to do that by using the additional data tab of the query, to display the collection of products attached to each profile. See Adobe Campaign Help | Query