SQL Workshop is where we confront the type of problems SQL devs face on a day to day basis. The example here is based on a real problem encountered in Ingres - but it has been simplified for the purpose of illustration. What do you do when you can't use a subselect within a Join? Full article here (i-programmer)
A dairy of my work.Just links to the full artices on i-programmer.info