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
- 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