I've come across an old database and was looking at some of the tables and sprocs.
I noticed a couple of things and wondered if I see syntax as below what does it mean?
Select tbl.id, tbl2.Name
So in short if there are two joins with an And does it mean it had to find rows in the tables where BOTH ids match?
Finally is a composite key the same as a foreign key? So a composite key in the above could be keeperId?