What does a join do? When is a join useful?

What will be an ideal response?


A join ties together two (or more) rows, each from a (usually) different
table, by means of a relationship between values in two (or more) columns,
one from each table.
A join is useful when you have two tables with a like column. It allows you
to view data from the two tables related by the like column.

Computer Science & Information Technology

You might also like to view...

By default, all new pinboards you create are public

Indicate whether the statement is true or false

Computer Science & Information Technology

A ________ IF function uses IF functions as arguments within another IF function

A) multiple B) composite C) nested D) multipart

Computer Science & Information Technology

A SQL query to joins two tables. In the query, it is necessary to ____ the Account Manager Number because it appears in more than one table.

A. restrict B. moderate C. qualify D. assign

Computer Science & Information Technology

The ____________________ tab contains several tools for adding citations to a document.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology