Shopping mall Multi-attribute filter, how to find!!

Shopping mall Multi-attribute filter, how to find!!

, want to find attr_id=8 value equals 2.2*2.0m and attr_id=10 is equal to the leather bed goods come out

Reply content:

Shopping mall Multi-attribute filter, how to find!!

, want to find attr_id=8 value equals 2.2*2.0m and attr_id=10 is equal to the leather bed goods come out

Let's first clarify the relationship between the two tables, which is the foreign key, which field in the table corresponds to which field in the other table, and mainly uses the multi-table union query join statement

Table 1 of the attr_id and table 2 attr_id is not the same ID, or you asked the wrong question

