Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command contains unrecognized phrase/keyword
Message
From
24/12/2006 10:10:15
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:
01180039
Views:
17
try,

SELECT stk_code,trn_type,trn_date,cst_prce,str_nmbr, ;
SUM(trn_qnty) AS m1_t ;
FROM test ;
WHERE !isnull(trn_qnty) and 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