:confused: Hi,
I am new to SQL-Server and just transferred my very complex Access database over. In Access it was possible to design a query of two related tables joined by a "one to many" relationship and delete the "many side" record without deleting the "one side" table record.
Now I tried to design a View in SQL server and if I try to delete a record in that view I get an error message saying that there are related records on the "one side" and deleting is not possbile.
Could somebody help please ...?

Hi,

Views are not for deletes only selects

either use query analyzer (if not permanent) or create a stored proc

also

are you aliasing the table correctly?

Hi SQL Hell,
Thanks for your quick reply! :)
What did you mean with aliasing the table correctly?

I meant something like this.....


delete a
from table1 a inner join table2 b on a.id = b.id