Why are naturl JOIN keywords not an option for producing a self-join?
I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.


