Consider two tables transaction and category each having their own ID and information.
A transaction can have more than one category, I have read creating a 3rd table to link transaction and category using their IDs is best. But what would you call this table, assuming you would have many like it?
transactionCategories is the best I'm coming up with, is there anything better?