Hello, I have 2 tables products and authors.
The primary key is productId
There may be many products in the product table for each author.
There may be many authors in the authors table for a product in the products table
I want to populate a table with the results that I will use to run fulltext queries against.
So if a product had multiple authors the product would appear in the results for each author
select p.title, p.productId, a.author
from products p, authors a
What type of join would get what I'm after?