SELECT
p.name AS pname,
p.icon AS icon,
p.price AS price,
p.original_price AS original_price,
p.prod_id AS prod_id,
p.stock AS stock,
p.views AS views,
s.name AS sname
FROM `product` as p
JOIN
`store` as s ON p.store_id = s.store_id
WHERE
p.active = "1"
ORDER BY `prod_id` DESC when s.store_id is removed,
this query is completely wrong.
what is the rewriting method
that can display data even if s.store_id is removed?
suppose five items
there are two items whose store_id value has been changed.
if you execute this sentence at this time, it will only show three words, and the other items will disappear. How do you understand this? I want him to show me?