YES!

Thats it :).

I knew it was pretty easy but i totally forgot how to do it.

Thanks alot

This is what i already know. I understand how joins work. Thats not the issue.

Still i know there is a way to get the productId even there is no result...

SELECT dbo.Product.Id, dbo.ProductStock.AvgCostPrice

FROM dbo.Product

LEFT OUTER JOIN dbo.ProductStock ON dbo.Product.Id = dbo.ProductStock.ProductId

WHERE dbo.Product.Family = '0001' AND dbo.Product.Number = '043001' AND (dbo.ProductStock.BranchId = 13)

This will never give a result because there...

Thats not the answer i'm looking for.

The BranchId will be in the query.

I'm confused with the results i get from the dm_db_missing_index_details.

If i understand correct i should add the indexes in de included_columns column.

While it shows indexes that we already made.

So which...