==I am on the net to imitate the database system of an electric suppliers, although than gourd used to come out, but to use the database or can't do that,

Want to know how do I find goods through individual conditions?

The following are some of the data, I according to their own understanding to fill in




If I want to put forward a commodity information from a database, for example: female jacket - & gt; Name of commodity prices - & gt; Goods corresponding with attributes, and corresponding parameter

Solving!!!!!! Urgent urgent!!!!!!!!!!

CodePudding user response:

The select statement, the select... The from...

CodePudding user response:

The select a.s ku_name, a.s ku_oding, Amy polumbo rice, a.u ndisconunted_price, from tb_sku a
Left the join sort_spu_r b on a.s pu_id=b.s pu_id
Left the join tb_sort c on b. enlei_id=c.f enlei_id
Where c.f enlei_name='female jacket'

Probably wrote down this is written well