mysql - 简单的 MySQL Join 来替换外键

Question

我有 2 张 table 、门票和状态。票证有一个外键状态，对应于state.id

SELECT tickets.id AS 'Ticket Id', 
       state.description AS 'State'
FROM tickets 
LEFT JOIN state ON tickets.state = state.id
WHERE tickets.id = 1;

因此，如果我的票证中有一行 Tickets.id = 1 且 Tickets.state = 1，并且状态中有一行 State.id = 1 且 state.description = 'Open'

如何获得结果 Ticket Id = 1，State = Open？

编辑:这确实有效，由于某种原因状态表是空的......

Answer 1

好像是这样

SELECT tickets.id AS 'Ticket Id', 
       state.description AS 'State'
FROM tickets 
LEFT JOIN state ON tickets.state = state.id
WHERE tickets.id = 1 and state.state = 'open';