Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

6 cards

()

Section 1

Preview this deck

How are cross products done?

Front

1 / 6

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (6)

Section 1

(6 cards)

How are cross products done?

Front

When there is less than N-1 conditions or a natural join without a matching column between two tables or if the two columns matched in a natural join have different data types

Back

What is a right outer join?

Front

return values that match in source and target tables as well as the values that don't match from the source table

Back

What is a left outer join?

Front

return values that match in source and target tables as well as the values that don't match from the source table

Back

What is a Cross Join or Cartesian Product?

Front

Gives every possible combination of two tables

Back

What is a full outer join?

Front

return values that match in source and target tables as well as the values that don't match from the source and target tables

Back

What is an inner join?

Front

only matching rows from both source and target tables are retained

Back