3 Replies Latest reply: May 15, 2014 9:02 AM by Fernando Tonial RSS

    help me how to write given MY sql quiery in QV

    balasundaram P

      SELECT TC.Name,TM.Type,TM.width,TC.N2NAME,TC.ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, TC.CircuitType ,TC.C2CTypeName,TC.C2CBandwidth,TM.Coverage,  TM.CITY,

      Count(1) CNT,SEQ,USAGE
      FROM
      Uc.master as TM,
      UC.tmcircuit AS TC
      GROUP BY  Name,TM.Type,
      N2NAME,ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, CircuitType ,
      C2CTypeName,TC.C2CBandwidth,TM.Coverage, TM.CITY,SEQ,USAGE



      my problem is COUNT function..........