I am new to MS Access!
I have a Table, with products and their categories. Each category (CAT) may have no product or multiple numbers of products. Now, I want to search for category which is having P1 and P2 products in it.
I am doing it in SELECT Query, but don't know how to do it..?
Need some help, please.
I have a Table, with products and their categories. Each category (CAT) may have no product or multiple numbers of products. Now, I want to search for category which is having P1 and P2 products in it.
I am doing it in SELECT Query, but don't know how to do it..?
Need some help, please.