Self referencing update SQL statement for Informix
- by CheeseConQueso
Need some Informix SQL...
Courses get a regular grade, but their associated labs get a grade of 'LAB'. I need to update the table so that the lab grade matches the course grade. Also, if there is no corresponding course for a lab, it means the course was canceled. In that case, I want to place a flag value of 'X' for its grade.
Example data…