Hi, I have 3 tables Description, Item, Transaction

            Description                 Item                Transaction
          DeID       Name      IID        Name     DeID     TranNo   Type     IID    Date
            1       Printer      1   Stylus T10      1         1     Repair    1
            2       Monitor      2          HP       1          2    Repair    3
                                 3       ViewSonic   2

    I need to count how many printers, Monitors etc. are in Item and how many are under repair

    eg.

    there are 2 printers in item, and 1 under repair

    output should be:

              Description           count              under repair
                Printer               2                      1
                Monitor               1                      1

    Im using vb.net 2010 and sql server 2008 r2
    as much as possible not using stored proc

    Thanks for your help
Re: HELP PLLLSSSS sql query for count and join from table related only from eac 80 80

anybody can help pllllssssssssss

Re: HELP PLLLSSSS sql query for count and join from table related only from eac 80 80

It's showing you marked this question solved. Were you able to solve this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.