[database].[dbo].[tablename]
pro.dbo.pro_details

SELECT
id,
Detail.code,
itemcode,
ITEM.Name1 AS item
FROM
pro.dbo.pro_details AS Detail
LEFT JOIN
pom.dbo.BCITEM AS ITEM
ON
ITEM.Code = Detail.itemcode