All pastes #2519 Raw Edit

Anonymous

public sql v1 · immutable
#2519 ·published 2004-12-01 04:54 UTC
rendered paste body
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'