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.
| Author |
Topic |
|
granders
Starting Member
6 Posts |
 Posted - 2001-04-30 : 20:20:53
|
| I have two tables, product and shoe_models.I can join the tables with:inner join shoe_models on product.product_id = shoe_models.fk_product_idproduct to shoe models has a 1 to many relationship.How can I add new rows into shoe models for all products of a certain type (prod_group = 3) based upon an existing row in shoe_models.To further clarify this. I have a particular shoe that has several product_id's of which each id can have multiple characteristics. I want to enter a base set of characteristics in shoe_models and use that record to create several records in shoe_models for products of a certain type. |
|
|
|
|
|
Insert statement using a join and several values