表已经含.(dot)，在join字段时需要再增加一个.(dot)，如何解决

Question

select alerttypeid, priorityid, message, name from mes.alert
outerjoin mes.alert_class
on mes.alert.alertid = mes.alert_class.id
order by generatedon
limit 10 offset 1

报错：

Msg 103010, Level 16, State 1, Line 1
Parse error at line: 3, column: 11: Incorrect syntax near 'mes'.

PS:如果直接上公司服务器，速度可以慢到要人命;我完全是SQL小白（看了几句sql语句就来搞了），所以想自己找点MES服务器的数据来玩。

Answer 1

select alerttypeid, priorityid, message, name from mes.alert as mes1
outer join mes.alert_class as mes2
on mes1.alertid = mes2.id
order by generatedon
limit 10 offset 1