verschachtelte Abfrage

[Frank (no reg)]

Hi,

wie sieht es mit folgendem SQL aus:

  
SELECT    [table_1].[tid],  
          [table_1].[spalte1],  
          [table_1].[spalte2]  
FROM      [table_1] INNER JOIN  
          [table_2] ON [table_2].[tid] = [table_1].[tid]  
GROUP BY  [table_1].[tid],  
          [table_1].[spalte1],  
          [table_1].[spalte2]  
ORDER BY  COUNT(*) DESC  
LIMIT 0, 10  

Ciao, Frank