Professional Web Applications Themes

delete distinct common records of TB1 and TB2 in TB1 - Microsoft SQL / MS SQL Server

Delete From TB1 Where Exists (select * from TB2 Where TB1.RMA = TB2.RMA AND TB1.Parts = TB2.Parts AND TB1.PPID = TB2.PPID) John "John Davis" <com> wrote in message news:032601c35ace$4be07570$gbl... ...

  1. #1

    Default Re: delete distinct common records of TB1 and TB2 in TB1

    Delete From TB1
    Where Exists (select *
    from TB2
    Where TB1.RMA = TB2.RMA
    AND TB1.Parts = TB2.Parts
    AND TB1.PPID = TB2.PPID)

    John


    "John Davis" <com> wrote in message
    news:032601c35ace$4be07570$gbl... 


    John Guest

  2. #2

    Default Re: delete distinct common records of TB1 and TB2 in TB1

    John Davis (com) writes: 

    delete TB1
    WHERE EXISTS (SELECT *
    FROM TB2
    WHERE TB1.RMA = TB2.RMA
    AND TB1.Parts = TB2.Parts
    AND TB1.PPID = TB2.PPID);



    --
    Erland Sommarskog, SQL Server MVP, se

    Books Online for SQL Server SP3 at
    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    Erland Guest

  3. #3

    Default delete distinct common records of TB1 and TB2 in TB1

    If there are duplicate rows in TB1 first eliminate those.
    Then delete the common records by executing the following
    query

    delete TB1
    from TB1
    join TB2 on (TB1.Parts = TB2.Parts AND TB1.PPID =
    TB2.PPID)

    Please refer to the following link for eliminating
    duplicate rows from TB1

    http://www.aspfaq.com/show.asp?id=2431

    HTH
    Srinivas Sampangi

     
    sampangi Guest

Similar Threads

  1. Why can't I delete these records?
    By Evert in forum MySQL
    Replies: 0
    Last Post: August 25th, 07:24 PM
  2. Delete records
    By Jonathan-harrogate in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: February 14th, 11:38 AM
  3. Distinct records only
    By ossie in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 22nd, 09:25 PM
  4. Replies: 2
    Last Post: September 30th, 02:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139