Before this week, my knowledge of SQL was essentially limited to "SELECT blah FROM blah JOIN blah ON blah WHERE blah". Now I'm being asked to do a little more, and while I think I'm getting up to ...

Any chance you can post the sql CREATE TABLE scripts for the tables and fields in question (obscufated if you like)? it would make things a bit easier I think. Also, the specific DBMS would be helpful ...