Shopping mall multi-attribute filtering, how to search! !

Multi-attribute filtering for shopping malls, how to search! !

As shown in the picture, I want to find products with attr_id=8 equal to 2.2*2.0m and attr_id=10 equal to leather art bed

Reply content:

Multi-attribute filtering for shopping malls, how to search! !

As shown in the picture, I want to find products with attr_id=8 equal to 2.2*2.0m and attr_id=10 equal to leather art bed

First explain clearly the relationship between the two tables, which is the foreign key, which field in the table corresponds to which field in the other table; mainly use the multi-table joint query join statement

Aren’t the attr_id of table 1 and the attr_id of table 2 the same id? Or is your question wrong?