Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niyaz4872
Starting Member
41 Posts |
 Posted - 2012-08-01 : 03:56:56
|
| SELECT (SELECT sum(RecordMoney) FROM vw_PayS_PersonInvoice WHERE (Company_ID='04') AND (Anbar_ID='13') AND (RecordType=7) AND (OperationDate < '13910101')) as test and group by SAL_FactorHdr.FactorHdr_ID FROM COM_Company INNER JOIN SAL_FactorHdr ON COM_Company.COM_ID = SAL_FactorHdr.FactorHdr_Com_ID RIGHT OUTER JOIN SAl_Customers ON SAL_FactorHdr.FactorHdr_Ctm_ID = SAl_Customers.Ctm_Id RIGHT OUTER JOIN vw_PayS_PersonInvoice ON SAL_FactorHdr.FactorHdr_Ctm_ID = vw_PayS_PersonInvoice.Tafzili_IDWHERE (SAL_FactorHdr.FactorHdr_Com_ID = '04') AND (SAL_FactorHdr.FactorHdr_Date >= '13910101') AND (SAL_FactorHdr.FactorHdr_Date <= '13911229') AND (SAL_FactorHdr.FactorHdr_ANB_ID = '13') AND (SAL_FactorHdr.FactorHdr_Ctm_ID IN ('600400', '600000')) GROUP BY SAL_FactorHdr.FactorHdr_Ctm_ID, SAl_Customers.Ctm_Name, SAL_FactorHdr.FactorHdr_Com_ID, SAL_FactorHdr.FactorHdr_ANB_ID, SAL_FactorHdr.FactorHdr_ID |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-08-01 : 04:47:31
|
Do you really think we can help without helpful information?And PLEASE do not do that duplicate posting...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
i can not slelect and where and group in select