Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between referencing and joining?
- 1 Answers
- 4131 Views
- I also Faced
- E-Mail Answers
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 |
Is it safe to delete log files?
Is sql server 2016 free?
What are the pros and cons of creating extended stored procedures?
How many columns can exist together per table?
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
What is the difference between stored procedure and functions?
How to connect PK and FK?
What is sql server programming?
How can we get count of the number of records in a table?
what is the sql equivaent of the dataset relation object ?
what is denormalization? : Sql server database administration
What are the various editions of sql server 2017 that are available in the market?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
