Home Forums Database Design Design Ideas and Questions How to design new query to take off invoice? RE: How to design new query to take off invoice?

  • December 30, 2008 at 6:07 am

    #918971

    Lakhbir.Bhatti (12/30/2008)

    If any invoices matching to code AS0630 that showing me the invoices are paid and take it off my list.

    select * from table as t

    where not exists(select * from table where invoiceno=t.invoiceno and activity='AS0630')

    Madhivanan

    Failing to plan is Planning to fail