2

When trying to join several tables, I receive the error

The multi-part identifier "tblOptionalExtensionSplit.Policy_ID" could not be bound.

and

Invalid column name 'Limit'.

SELECT tblpolicy.Policy_ID,
    tblpolicy.APRA_Code, 
    tblpolicy.APRA_Description, 
    tblpolicy.side_c, 
    tblOptionalExtensionSplit.Limit, 
    tblBurnAnalysis.*, 
    tblOptionalExtension.Optional_Extension_ID, 
    tblOptionalExtension.Optional_Extension, 
    tblOptionalExtension.Limit 

FROM tblOptionalExtension

INNER JOIN tblPolicy
    ON tblOptionalExtensionSplit.Policy_ID = tblPolicy.Policy_ID 
INNER JOIN tblBurnAnalysis
    ON tblPolicy.Policy_ID = tblBurnAnalysis.Policy_ID
INNER JOIN tblOptionalExtensionMatrix
    ON tblOptionalExtension.Optional_Extension_ID = tblOptionalExtensionMatrix.Optional_Extension_ID
INNER JOIN tblOptionalExtensionSplit
    ON tblOptionalExtensionMatrix.Optional_Extension_Matrix_ID = tblOptionalExtensionSplit.Optional_Extension_Matrix_ID

WHERE tblOptionalExtension.Optional_Extension = 'Company Securities Liability'

and Limit > 0
buddemat
  • 4,552
  • 14
  • 29
  • 49
Dlee
  • 21
  • 2

0 Answers0