![]() However, you can simply drag AdultID in the Children table, and drop it onto the AdultID in the Parents table to create the relationship. If they are not automatically joined (by the line that appears between the tables) you have not set AdutlID in the Children table as a foreign key. If we open up the Query Designer in Sql Server Management Studio, and add the 2 tables, they are joined on the AdultID by default using an INNER JOIN. Children are related to Parents by the AdultID. This is how they appear in database tables: Parents and Children.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |