sencillo:
Código SQL:
Ver originalSELECT * FROM(
SELECT T1.intGeneralCargoUniversalId AS Universal_ID,
T1.intGCInventoryItemId AS Item_Inventario,
T1.intGCInvItemQuantity AS Cantidad,
T1.decGCInvItemWeight AS Peso,
T1.dtmGCInvItemReceptionDate AS Fecha_Captura,
T1.strGCInvItemCreatedBy AS Capturado_por
FROM tblclsGCInventoryItem T1
WHERE T1.intGeneralCargoUniversalId IN (SELECT intGeneralCargoUniversalId
FROM dbCalathus.dbo.tblclsGeneralCargoInventory AS T2
WHERE T2.blnGCInventoryActive =1) AND T1.intGCFiscalStatusId=1 ORDER BY T1.intGeneralCargoUniversalId
) AS tabla1
LEFT JOIN
(
SELECT strProductName
FROM dbCalathus.dbo.tblclsProduct T3
WHERE T3.intProductId IN (SELECT intProductId
FROM dbCalathus.dbo.tblclsGeneralCargoInventory AS T2
WHERE T2.blnGCInventoryActive =1)
) AS tabla2 ON (tabla1.id=tabla2.id)
Magia ;)