R
R
Ruslan Absalyamov2018-06-14 15:05:27
MySQL
Ruslan Absalyamov, 2018-06-14 15:05:27

Why is my second table showing null?

I have such a query, but I don’t understand why I have a second table that I do LEFT JOIN and display empty

SELECT BI.NAME FROM b_iblock_element AS BIE 
LEFT JOIN b_iblock AS BI ON BIE.IBLOCK_ID = BI.ID AND BI.CODE = "stol"
WHERE BIE.IN_SECTIONS = "Y"
AND BIE.ACTIVE = "Y"

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question