>Thanks to both you and Sylvain. You guys both responded with just about the same way to do this (convert bit to int) so I guess it's how it's done. > >Just one more thing: I purposesly made the SELECT short but if I have a lot fields in the Invoice table that I need to retrieve, this means I have to specify every fields I need instead of doing "SELECT A.*..." which would be PITA.
No you don't have to list them in the Select field list but you'll have to in the GROUP BY clause.