Hi All, 

I have created a sql query but if I run it , I get this following error 

"Id  is an unknown attribute of AssetLocationStatus at GetClaimStatusChangeRequestList"

Please assist with the below query. Thanking you in advance

SELECT Distinct 
'InstructionCode' = {Instruction}.[Code],
'Status' ,
'AssetLocationStatus' = {AssetLocationStatus}.[Label],
'FromClaimStatus' = {InstructionClaimStatus}.[Id],
'ToClaimStatus' = {InstructionClaimStatus}.[Id],
'RequestedBy' = {User}.[Id],
'RequestedOn' = {ClaimStatusChangeRequest}.[RequestedOn]
'UpdatedBy' = {User}.[Id],
'UpdatedOn' = {ClaimStatusChangeRequest}.[ModifiedOn]

from Instruction
inner join {SalvageAsset} ON {Instruction}.[SalvageAssetId] = {SalvageAsset}.[Id]
inner join {InstructionClaimStatus} ON {Instruction}.[InstructionClaimStatusId] = {InstructionClaimStatus}.[Id]
inner join {ClaimStatusChangeRequest} ON {InstructionClaimStatus}.[Id] = {ClaimStatusChangeRequest}.[InstructionClaimStatusToId]
inner join {User} ON {ClaimStatusChangeRequest}.[RequestedBy] = {User}.[Id]
inner join {User} ON {ClaimStatusChangeRequest}.[ApprovedBy] = {User}.[Id]
inner join {InstructionBusinessUnit} ON {Instruction}.[FMSBusinessUnitId] = {InstructionBusinessUnit}.[Id]
inner join {AssetLocationStatus} ON {SalvageAsset}.[AssetLocationStatusId] = {AssetLocationStatus}.[Id]

where {ClaimStatusChangeRequest}.[InstructionClaimStatusToId] IN (7,11)
and {Instruction}.[Code]  like '%' + @Search_Keyword + '%' or
{Instruction}.[ClaimNumber]  like '%' + @Search_Keyword + '%' or
{Instruction}.[PolicyNumber] like '%' + @Search_Keyword + '%'
and
{ClaimStatusChangeRequest}.[RequestedBy] = @Search_RequestedBy or @Search_RequestedBy = 0
and
{ClaimStatusChangeRequest}.[ApprovedBy] = @Search_ApprovedBy or @Search_ApprovedBy = 0
and
{AssetLocationStatus}.[Id ]= @Search_AssetLocationStatusId or @Search_AssetLocationStatusId = 0
and
{Instruction}.[FMSBusinessUnitId] = @Search_BusinessUnit or @Search_BusinessUnit = 0