Inserting, deleting, updating with joins

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Inserting, deleting, updating with joins

Author

Topic

dollarbillg
Yak Posting Veteran

52 Posts

Posted - 2003-03-14 : 11:22:25

I have a select statement that uses a join. What I need to be able to do now is modify the dataset that was returned from the select statement. Specifically, insert and delete records to the dataset. Is it possible to insert data using a join.

Thanks

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-03-14 : 11:38:28

nope.

You may be able to define a view as your select and perform dml on the view. There are rules about views and when they are updateable. Read more in Books Online about that.

Jay White
{0}

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-03-14 : 12:49:29

Can't you use the SELECT INTO method? The table can't already exist, but you can send it into some temporary table and then move the data from the temporary table into the permanent table.

SELECT a.Column2, b.Column3, b.Column4
INTO SomeTable
FROM Table1 a
INNER JOIN Table2 b ON a.Column1 = b.Column1
WHERE a.Column3 > 0

Won't this work?

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources