How to find categories in which there are no products?

E

Evgeny2016-11-02 03:36:10

MySQL

Evgeny, 2016-11-02 03:36:10

There are 3 tables
Structure Lst_Cat (CatId, CategoryParentId, Name)
Structure Lst_Goods (GoodId, Name)
Structure Lst_GoodsToCat ( GoodToCatId, GoodId, CatId)
1. How to find products without categories?
2. How to find categories in which there are no products?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

A

Anholle2019-09-09 11:37:42

How to set up a filter in the feedback form? 0Reply

P

Pavel2014-05-18 14:34:20

How to set up Chrome DevTools Autosave on windows? 4Reply

I