CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: f.a.s.t

Search: Search took 0.02 seconds.

  1. April 14th, 2010, 08:28 PM

    Thread: Sum column in one table with different criteria

    by f.a.s.t
    Replies
    1
    Views
    1,111

    Re: Sum column in one table with different criteria

    Hi, there are some changes to the codes

    SELECT T0.DocDate, SUM (T1.[LineTotal]) as "APBASE", ROUND((sUM(T1.LineTotal)*0.07),2) AS "APGST"
    FROM OPCH T0 INNER JOIN PCH1 T1
    ON T0.DocEntry =...
  2. April 14th, 2010, 05:11 AM

    Thread: Sum column in one table with different criteria

    by f.a.s.t
    Replies
    1
    Views
    1,111

    Sum column in one table with different criteria

    Hi,

    Could anyone advise how to select in one query instead of two??

    SELECT T0.DocDate, SUM (T1.[LineTotal]) as "APBASE", ROUND((sUM(T1.LineTotal)*0.07),2) AS "APGST"
    FROM OPCH T0 INNER JOIN...
Results 1 to 2 of 2





Click Here to Expand Forum to Full Width

Featured