SQLTeam.com | Weblogs | Forums

Unable to do Inner Join between two tables


#1

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


#2

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


#3

I don't get any results at all, see image


#4

Thank you James