Introduction to Joins ACCTCY 4328

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/5

flashcard set

Earn XP

Description and Tags

Final

6 Terms

1
New cards

Tables are related based on common ___.

Keys (similar fields)

2
New cards

How do we organize data in a meaningful way from different tables

join/link the related tables

3
New cards

Inner Joins

Record must have a match in the corresponding table to be included in the output

4
New cards

Inner Join EXAMPLE

SELECT <select_list>

FROM TableA A

INNER JOIN TableB B

ON A.Key = B.Key

5
New cards

Outer Join [ Left Join ]

Keeps all records from the “Left” table regardless of whether the record has a match in the other table

6
New cards

Outer Join EXAMPLE

SELECT <select_list>

FROM TableA A

LEFT JOIN TableB B

ON A.Key = B.Key