But can you offer an example? A sample?
I don't mean to appear dense but this is one of those areas where every time I attempt to apply what I think I know, it confounds me.
I understand the idea of normalizing a relational database. So, assuming I have these fictitious tables:
id, fname, lname, country, fav_color
id, order_number, user_id, item_id
If I wanted to get the number of orders each user placed that included an item of their favorite color. Is this a good example of where to use a JOIN?
I want to keep this discussion simple. At the same time, PLEASE correct my illustration where you can better facilitate edifying me.