DaniWeb Forum Index
>
Search Forums
RSS
Search Results
•
•
•
•
Showing results 1 to 1 of 1
Search took
0.00
seconds.
Search:
Posts Made By:
huangzhi
; Forum:
MS SQL
and child forums
Save these search results for 24 hours
Forum:
MS SQL
18 Days Ago
Replies:
6
Solved:
joining 3 tables messes up SUMS
Views:
582
Posted By
huangzhi
1
I think there are some (ClientID = 1126) in table...
I think there are some (ClientID = 1126) in table Receipts.
Change your SQL to:
SELECT Clients.ClientID, Clients.WholeName,
SUM(CASE WHEN Payments.Creditorid = 0 THEN Payments.Amount ELSE...
Showing results 1 to 1 of 1
You need to
join our community
in order to build your list of favorite forums. You can visit the
forum index
for a listing of all forums.
Latest Posts
Today's Posts
All Forums
Unanswered Threads
All Forums
Related Forum Features
DaniWeb News Stories
DaniWeb Code Snippets
DaniWeb Tutorials
DaniWeb Product Reviews
DaniWeb White Papers
Forum Search
About Us
|
Contact Us
|
Advertise
|
DaniWeb
|
Acceptable Use Policy
|
©2003 - 2009 DaniWeb® LLC
