Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
INSERT doable in SQL?
-- The repeating refPersonGroupId violate First Normal Form Ok, I oversimplified what I'm actually dealing with because my ability to draw clear ascii art is limited to two tables. In reality, refPersonGroupId1 and refPersonGroupId2 don't point to the same table. They point to two different... -
INSERT doable in SQL?
Actually error is 'number of query values and destination fields are not the same' -
INSERT doable in SQL?
PHV and Gomom - I read PHV's link... are you saying that this won't work? I'm trying to simplify what I'm really doing into something that's easy to post and comment on. In reality there are two fields that are references to the primary key of another table that need to be updated (hopefully... -
INSERT doable in SQL?
PHV - One more quick addition to the last addition. Your query works great. Now, if I need to add on additional groups, like refPersonGroupId1, refPersonGroupId2, refPersonGroupId3... how would I extend your query? I tried this, but it didn't work: INSERT INTO tblPerson (PersonFirstName... -
-
INSERT doable in SQL?
Is this doable with one SQL query? There are two tables: tblPerson ---------------- PersonId PersonFirstName PersonLastName -> refPersonGroupId | | | (linked by) | | | tblPersonGroup | ---------------- -> PersonGroupId PersonGroupName So...
