Hello Community,
Can someone let me know why the following inner join script won't work on the following tables:
SELECT
*
FROM dbo.prodtypehist
INNER JOIN dbo.product
ON prodtypehist.PRODUCT_ID = product.PRODUCT_ID
Hello Community,
Can someone let me know why the following inner join script won't work on the following tables:
SELECT
*
FROM dbo.prodtypehist
INNER JOIN dbo.product
ON prodtypehist.PRODUCT_ID = product.PRODUCT_ID
What do you mean when you say the join script won't work?
Are you getting a syntax error? If you are, post the error message.
If the script is running, but you are not getting any rows in the output, that means there are no matching rows in the two tables, i.e., there is no row in the dbo.product table that has a product_id equal to the product_id in any row in the dbo.prodtypehist table
Thank you James