I am trying to write a simple query but has the above error message for one of the tables that I am trying to reference. I am assuming that it has something to do with the table itself and the properties of it. Can anyone tell me what property it needs besides have a primary key and identity column? when writing the query, SQL does not want to recognize that this is part of the database. I am sure it is something simple overlooked, any assistance would be helpful.
The table of dbo.DDaPDischargeTranslati
on is the one that cannot be bound in this instance. Thanks.
SET dbo.DDAPTransmittal.DischargeReason = dbo.DDaPDischargeTranslation.DDaP_DCCode
LEFT JOIN dbo.DDaPDischargeTranslation
ON dbo.DDAPTransmittal.DischargeReason = dbo.DDaPDischargeTranslation.DC_Code;