Can anyone help me understand why the following query:
SELECT products.id, merch.id FROM products, merch;
Would return the results from the product table two times, and the results from the merch table three times?
Right now there is just dummy content in my tables (two products in one, and three in the other), and there is no duplication. Let me know if you need more information. I am sure (hoping) it is something simple that I am doing wrong.