Delete Query With Join

[javiervasquez_94]

Hi,

I'm using MS SQL and have 2 tables.

table1 has 384 records
table2 has 252 records (that are duplicates of 252 of table1's rows)

I can perform the join to tell me there are 252 rows that match:

SELECT COUNT(*) AS Expr1
FROM table1 INNER JOIN
table2 ON table1.part_number = table2.part_number

How do I format the query so I can DELETE the 252 rows of table1 so I'm left with only the 132 rows that aren't contained in table2?

Thanks

[r937]

delete
  from table1 
 where part_number
    in ( select part_number
           from table2 )

[javiervasquez_94]

delete
  from table1 
 where part_number
    in ( select part_number
           from table2 )

That seems incredibly simple after spending a couple of hours on it....

thanks very much.

[javiervasquez_94]

Sorry, one other question...

How do I then write a query to UPDATE a third table...

UPDATE    table3
SET      table3.qty = (SELECT     *
		FROM   table3 INNER JOIN
                      table2 ON  table2.prod_num = table3.prod_num )

Basically I want UPDATE the qty value of an existing table (table3) that contains the 252 records in table2...

Hope that makes some sense??

[r937]

update table3
   set qty = t2.qty
  from table3 t3
inner
  join table2 t2
    on t3.prod_num = t2.prod_num