Select products.productid, product_name, product_description, origin, image_name, price
from products, origins, images, prod_origins
Where products.productid = prod_origins.productid
And products.productid = images.productid
And product_name like '%tostee%'
The results I get are correct except the origins column is showing multiple matches for the same description when there should only be two matches. All the other columns are duplicate data in the query except origins. It is showing multiple origins for each name/description/price. I've attached the sql file with all the info for each table if that helps. thanks!!
Number of downloads: 115