Hi All,
I am having difficulties developing a query to return rows that include all of the requested criteria in a single field. Because of the nature of the data in my database I will make a short example to explain my situation.
I have a clothing catalog with shirts. They come in sizes ranging from sm to XL, though not all shirts include every size. To assign which sizes apply to which shirts I have set up the appropriate association table (many-to-many).
My issue is that I cannot construct a query that returns all shirts with the explicit sizes I request. I want shirts that have ONLY medium AND large, but if I try putting that into the criteria it won't return anything since one cell contains one size.
How would I go about doing this?
I am having difficulties developing a query to return rows that include all of the requested criteria in a single field. Because of the nature of the data in my database I will make a short example to explain my situation.
I have a clothing catalog with shirts. They come in sizes ranging from sm to XL, though not all shirts include every size. To assign which sizes apply to which shirts I have set up the appropriate association table (many-to-many).
My issue is that I cannot construct a query that returns all shirts with the explicit sizes I request. I want shirts that have ONLY medium AND large, but if I try putting that into the criteria it won't return anything since one cell contains one size.
How would I go about doing this?