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
 SQL Server Development (2000)
 Deleting multiple records in n-n relationships

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-29 : 11:53:17
Linda writes "Hi!

Need some help on how to delete a record in a n-n relationship. Got two tables, "animals" and "fruit" (well...let's pretend anyway), with a many-to-many relationship between them. Thus normalized with an additional table, "eat". Animals have anim_ID, fruits has fruit_ID as primary keys.
How do I do if I want to delete a record containing an animal, along with his food preferences?

Please help me fast!

Regards,

Linda"
   

- Advertisement -