How do I SELECT FROM..WHERE then JOIN in SQL?

Question

I'd like to SELECT all records from a table that match 'status' as 'Open', and THEN perform a left join with another table. I've tried this, but it doesn't work:

SELECT (ticket.* WHERE ticket.status = 'Open'), ticketupdate.updatetime
FROM ticket
INNER JOIN ticketupdate ON ticketupdate.ticketid = ticket.ticketid

Answer 1

Simple you can do left join with where clause

select tk.*, tu.updatetime 
from ticket tk 
left join ticketupdate tu on tu.ticketid  = tk.ticketid 
where tk.status = 'Open';