- #1
FrankJ777
- 140
- 6
I'm trying to learn SQL, specifically for SQL server. One question I have is about defining relationships. I know how to build a relationship graphically (showing that the primary key from one table is the foreign key of another), but I'm not sure how to assert the relationship with an equivalent SQL statement. Is this possible?
Also, what is the purpose of defining a relationship? It seems that for any query I could accomplish the same thing using a JOIN operation.
Any attempt to enlighten me would be most appreciated.
Thanks
Also, what is the purpose of defining a relationship? It seems that for any query I could accomplish the same thing using a JOIN operation.
Any attempt to enlighten me would be most appreciated.
Thanks