Web App Special

ScribeFire

ScribeFire is an extension for the Mozilla Firefox Web browser, Google Chrome Web browser, and Apple Safari Web browser that allows you to easily post to all of your blogs.

[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