Hi,
I face a bit of a challenge: I have one table where I score categories by project. Those cateries are active if they are selected in the category table. I would need to make sure that the rating table has a record for each selected category for each project.
I have a query to get all selected categories per project
and one to see which ones exist
Is there a way to substract one from another (filter on both column project ID and category) to insert them in T_NewProjPrioRatings?
I face a bit of a challenge: I have one table where I score categories by project. Those cateries are active if they are selected in the category table. I would need to make sure that the rating table has a record for each selected category for each project.
I have a query to get all selected categories per project
SQL:
SELECT T_Projets.pr_ID, T_NewPrioCategories.np_CategoryName
FROM T_Projets, T_NewPrioCategories
WHERE (((T_NewPrioCategories.np_Selected)=True))
ORDER BY T_Projets.pr_ID, T_NewPrioCategories.np_CategoryName;
SQL:
SELECT T_NewProjPrioRatings.pr_ID, T_NewProjPrioRatings.np_ProjPrioCategory
FROM T_NewPrioCategories INNER JOIN T_NewProjPrioRatings ON T_NewPrioCategories.np_CategoryName = T_NewProjPrioRatings.np_ProjPrioCategory
WHERE (((T_NewPrioCategories.np_Selected)=True));
Is there a way to substract one from another (filter on both column project ID and category) to insert them in T_NewProjPrioRatings?