sql-join Flashcards
1
Q
What is a foreign key?
A
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
2
Q
How do you join two SQL tables?
A
JOIN “tableName” using (“attribute”)
if column names are not the same
on tableName1.attribute1 = tableName2.newAttribute
3
Q
How do you temporarily rename columns or tables in a SQL statement?
A
by using the “as” keyword
