When I delete a record from a certain table, I need to delete a
(possibly) attached note as well. How can I do this with postgres? The
tables are like this:
reservation
reservation_id
stuff...
isuse
issue_id
reservation_id
stuff..
note
issue_id
text comments...
A select that pulls out what I want to delete is:
SELECT reservation_id,issue_id,note_id,eg_note.comments FROM
eg_reservation
LEFT JOIN eg_issue USING (reservation_id)
LEFT JOIN eg_note USING (issue_id)
WHERE reservation_id > condition;
Can anyone help me turn this into a DELETE statement?