sql-join

Question 1

What is a foreign key?

Answer 1

foreign key is attribute data that is present/shared by more that one table aka a shared data value/attribute.. foreign keys can be foreign keys even if they have different names

Question 2

How do you join two SQL tables?

Answer 2

JOIN “tableName” using (“attribute”)

if column names are not the same
on tableName1.attribute1 = tableName2.newAttribute

Question 3

How do you temporarily rename columns or tables in a SQL statement?

Answer 3

by using the “as” keyword