Post reply

Query problem

  • March 31, 2005 at 7:53 am

    #88033

    First let me give the reference information:

    Tables: ('quick2' and 'tmt2')

    Both tables have a column named 'Num' which I would like to use to compare the tables.

    What I really would like to do is delete all the rows from 'quick2' where quick2.Num and tmt2.Num are equal, then use a select statement to retrieve the remaining rows from quick2.

    I exhausted every command my limited skills allow.

    Any help appreciated

     

    Brusse James

  • March 31, 2005 at 9:02 am

    #549859

    Delete from dbo.Quick2 Q where exists (Select * from dbo.tmt2 T where Q.num = T.Num)

    Select * from dbo.Quick2

  • March 31, 2005 at 9:42 am

    #549867

    Thanks for your help, that did it.

  • March 31, 2005 at 9:43 am

    #549868

    Happy to help.

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

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