help me how to write given MY sql quiery in QV

[balasundaram]

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..........

[fernando_tonial]

Put Before SQL

SQL 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  TC.Name,
  TM.Type,
  TM.width,
  TC.N2NAME,
  TC.ACTUALNAME,
  TC.APORTNAME,
  TC.ZPORTNAME, 
  TC.CircuitType,
  TC.C2CTypeName,
  TC.C2CBandwidth,
  TM.Coverage,  
  TM.CITY,
  SEQ,
  USAGE;

Best Regards.

Tonial.

[balasundaram]

i need to write that procedure in the form of QV script. and also i need to load that data from "master.qvd" and "tmcircuit.qvd"

[fernando_tonial]

Try this:

Master:
LOAD *, 1 AS CNT FROM master.qvd (qvd);

Inner Join (Master)
LOAD * From tmcisrcuit.qvd(qvd);

Best Regards.

Tonial.