I'm having a bit of a problem with some SQL. I'm trying to do a match from one table to another. It works perfectly except for the last line. As soon as I add it NOTHING gets updated. I'm using SQL ...

I have an app that I'm building where I'm storing family information in one table, and then the members of a family in another. This just seems to make the most sense. Here's a boiled down version of ...