Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between referencing and joining?
- 1 Answers
- 4138 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramachchandran
referencing:
ex: table A--> having primary key
table B--> having foreign key. now referencing means
this table B refers table A using the particular field u
mentioned as primary key and foreign key.
joining:
we can perform joining operation only if two table
have primary key and foreign key relationship. using this
keys we can perform inner, left outer,fullouter,right outer
joins.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you insert values in multiple rows using one Insert statement?
Different types of keys in SQL?
What is temporal data type?
What is GUID in sql server?
What is report snapshot?
How to use union to merge outputs from two queries together in ms sql server?
What are the acid properties?
What is mssql?
What are the differences between char and nchar in ms sql server?
How to include date and time values in sql statements?
What is an execution plan? When would you use it?
What is the difference between primary key and unique constraints?
What happens when unicode strings concatenate with non-unicode strings?
How to rebuild master databse?
How to create a user name in a database?
