Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command contains unrecognized phrase/keyword
Message
From
24/12/2006 10:14:17
Suhas Hegde
Dental Surgeon
Sirsi, India
 
 
To
24/12/2006 09:54:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180003
Message ID:
01180041
Views:
15
also try,

SELECT stk_code,trn_type,trn_date,cst_prce,str_nmbr, ;
SUM(nvl(trn_qnty,0)) AS m1_t ;
FROM test ;
WHERE MONTH(trn_date)=1 AND trn_type=1 and between(trn_date,ldStart,ldEnd) ;
GROUP BY stk_code,trn_type,trn_date,cst_prce,str_nmbr
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform