I'm getting a syntax error on a column that I'm using to join two tables. It's a simple join and query and I can't see why it would be giving me that error.
from dbo.APM_MASTER__CHECK cm
join dbo.APM_MASTER__DIST_PAYMENT dp
on cm.Vendor = dp.Vendor and cm.Payment_ID = dp.Payment_ID and cm.Check = dp.Check
Incorrect syntax near 'Check' and both the cm.Check and dp.Check are underlined in red. I do much more complicated joins all the time so there must be something about that word that is tripping me up. Can anyone help me please?