SELECT 
 t1.id, 
 t1.name, 
 t1.tcat, 
 t1.lastin, 
 t2.scat 
  FROM suppliers t1
  INNER JOIN  categories t2 ON t1.tcat = t2.id
   WHERE 1=1
    AND t1.lname LIKE '%' 
    OR t1.lname = 'b' 
    LIMIT 0, 30