>Date: Fri, 18 Feb 2011 07:34:06 -0800 >From: Jim Morris <jmor...@bearriver.com> > >A correlated sub-query might work for you. > >SELECT > [Analyzers].[AnalyzerID] > , [Analyzers].[Name] AS [Analyzer] > , [Analysis].[AnalysisID] > , [Analysis].[ScanID] > , [Analysis].[Timestamp] > , [Analysis].[EndTime] > , (SELECT COUNT(*) AS NumDefects FROM Defects d where d.AnalysisID = Analysis.AnalysisID) as NumDefects, > , [Analysis].[Result] >FROM [Analysis] >JOIN [Analyzers] ON [Analyzers].[AnalyzerID] = [Analysis].[AnalyzerID] >ORDER BY [Analysis].[Timestamp];
Thank you, Jim. This is very handy technique for me know as I am still a SQL beginner. -- Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users