This is the setup:
Table A has a connection to table B. There are multiple entries (0 to n) in table B that can have a matching record in table A.
How do I form a query that gives me a record from table A only if a certain amount of matching records exist in table B?
Table A has clothing in it. Table B has attributes for clothing.
Table B has a foreign key to table A so it would look something like this:
id fid_clothing1 attributeA id fid_clothing1 attributeB id fid_clothing1 attributeC id fid_clothing2 attributeA id fid_clothing2 attributeB
Now, I want only the clothes which have attribute
attributeC. This is not a problem if I do a OR-query but I can't just do something like:
SELECT * from tableA LEFT JOIN tableB on tableB.fid_cloting = tableA.id WHERE attribute='A' AND attribute='B' AND attribute='C'
This condition will never evaluate to true. How do I do that?