SQL高手: sql语句按条件联接两个表,其中一个表要先进行分类筛选,另一...答:CREATE TABLE #t1 (type1 varchar(2),type2 varchar(2));CREATE TABLE #t2 (bh varchar(2),name varchar(6),typ varchar(6));INSERT INTO #t1 SELECT 'a', '1' UNION ALL SELECT 'b', '2' UNION ALL SELECT 'c', '3';INSERT INTO #t2 SELECT 'a', '类1a', ...