I an very new to Databases
Currently studying Access, SQL and using Coldfusion
I was reading in SQL you can use FROM and WHERE to JOIN two tables in a query. Where does the Primary key come in? Or is it even needed based on what you are using? Does the primary key need to be assigned on the tables in order to use that function?
I am confused, please help.