Sergey_5

var n = 10;
switch (true) {
  case n < 10: console.log(1); break;
  case n === 10: console.log(2); break;
  case n > 10: console.log(3); break;
}

SELECT prod_name,
       prod_description
FROM tb_product
WHERE prod_nomenclature IN
    (SELECT comm_product_nomenc
     FROM tb_comm
     WHERE comm_user_id=1)

SELECT * FROM tb_comm
 LEFT JOIN tb_product ON tb_comm.common_product_nomec = tb_product.prod_nomenclature
WHERE tb_comm.comm_user_id = $_SESSION['user_id'];