SELECT TOP 30
 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 = 'b'