Post reply

Inner select count(*) is not returning any data.

  • December 18, 2021 at 8:46 am

    Go to Answer

    #3965045 

    Hi 
    Inner select count(*) is not returning any data.

    SELECTT1.U_VendCode,T1.U_CabNo,T1.U_VendName as "Vendor Name",Count(*),(Select Count(*) from [tbl1] where U_APDE = 'Y'),T1.U_CustCode as "Cust Code",T1.U_CustName as "Cust Name",T1.U_ItemCodeFROM [tbl0] T0inner join [tbl1] T1 on T0.Docentry = T1.DocEntrywhere NOT(T1.U_APDE = 'N' AND T1.U_ARDE = 'N') and (T1.U_ItemCode is not null) and (T0.U_DATE BETWEEN '2021-03-01' and '2021-03-31' )and T1.U_CustCode = 'SS'group by T1.U_VendCode,T1.U_CabNo,T1.U_VendName,T1.U_Custcode,T1.U_Custname,T1.U_APDE,T1.U_ARDE,T1.U_ItemCodeThanks

    • This topic was modified 2 years, 11 months ago by  jagjitsingh.

  • December 18, 2021 at 9:39 am

    #3965062

    As usual, code not formatted and no question is asked.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 18, 2021 at 9:46 am

    #3965066

    Hi

    I have asked the question Inner select count is not returning any Data

    Thanks

  • December 18, 2021 at 10:14 am

    Answer

    #3965070

    Hi

    Closed . Field was wrong

    Thanks

  • December 18, 2021 at 1:56 pm

    #3965100

    jagjitsingh wrote:

    Hi

    I have asked the question Inner select count is not returning any Data

    Thanks

    That is a statement, not a question. It's similar to me saying: "I am not a turnip".

     

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply