The 'command' used to change contents of one database using the contents of another database by linking them on a common key field?
Please confirm the answer for this question. I think answer should be update.
Refer: https://www.javatpoint.com/sql-update-with-join
ans is (b)
join clause combines columns from one or more tables in a relationaldatabase. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining columns from one (self-table) or more tables by using values common to each.
Answer is B
Replace command in sql : Replaces all occurrences of a specified string value with another string value
Change : I don't think any command in db is there with Change key word
Update : Update a record in table
64.3k questions
77.9k answers
243k comments
79.7k users