Re: How to use DISTINCT for two attributes combined

SELECT COUNT(DISTINCT A.a1 || A.a2)
  FROM FirstRel AS A, SecondRel AS B
 WHERE A.a3 = B.b1
 GROUP BY B.b2, B.b3;

Since this is SQL Server, use + for concatenation instead of the standard symbol. Received on Mon Jul 28 2003 - 11:48:00 CDT