7 Replies Latest reply on Oct 3, 2007 9:57 PM by Aketi Jyuuzou

    count problem

      I have a table with two columns: id, package
      id package
      1 TV
      2 CD
      1 CD
      1 DVD
      3 TV
      I want get the id which has package 'TV' and his total records in this table is less than 4.
      How should i do? Thanks