[mrsbagdirt]

I get the following error when running the query below:

Tables or functions 'AST_CMDB_Associations' and 'AST_CMDB_Associations' have the same exposed names. Use correlation names to distinguish them.

I have looked up information regarding correlation names but it just doesn't make sense to me. It's obvious I don't really know what I am doing. Can anyone help? Thanks in advance.

UPDATE AST_ComputerSystem
SET AST_ComputerSystem.Supported = '1'
from AST_CMDB_Associations, AST_ComputerSystem, AST_AssetWarranty
INNER JOIN AST_ComputerSystem ON AST_ComputerSystem.Reconciliation_Identity = AST_CMDB_Assocations.Request_ID01
INNER JOIN AST_CMDB_Associations ON AST_AssetWarranty.instanceId =
AST_CMDB_Associations.Request_ID02
WHERE((AST_AssetWarranty.Expiration_Date >Currentdate))

[code green]

Must admit not familiar with this one.
But at a guess it is likely because you have JOINed to the same table.
Nothing wrong with that but you need to alias them both,
then refer to the alias in the table.fieldname prefix

Expand|Select|Wrap|Line Numbers

from AST_CMDB_Associations aca, AST_ComputerSystem, AST_AssetWarranty INNER JOIN AST_ComputerSystem ON AST_ComputerSystem.Reconciliation_Identity = aca.Request_ID01 INNER JOIN AST_CMDB_Associations acma ON AST_AssetWarranty.instanceId =

Or something along those lines

[iburyak]

Try this:

Expand|Select|Wrap|Line Numbers

UPDATE AST_ComputerSystem SET AST_ComputerSystem.Supported = '1' from AST_AssetWarranty INNER JOIN AST_CMDB_Associations ON AST_AssetWarranty.instanceId = AST_CMDB_Associations.Request_ID02 INNER JOIN AST_ComputerSystem ON AST_ComputerSystem.Reconciliation_Identity = AST_CMDB_Assocations.Request_ID01 WHERE(AST_AssetWarranty.Expiration_Date > Currentdate)

Good Luck.

[mrsbagdirt]

That did it! Thanks so much for the help.

Originally Posted by iburyak

Try this:

Expand|Select|Wrap|Line Numbers

UPDATE AST_ComputerSystem SET AST_ComputerSystem.Supported = '1' from AST_AssetWarranty INNER JOIN AST_CMDB_Associations ON AST_AssetWarranty.instanceId = AST_CMDB_Associations.Request_ID02 INNER JOIN AST_ComputerSystem ON AST_ComputerSystem.Reconciliation_Identity = AST_CMDB_Assocations.Request_ID01 WHERE(AST_AssetWarranty.Expiration_Date > Currentdate)

Good Luck.