Sense, Nonsense, and Not-Sense

re 4 - depending on the db format, there are ways to do it if you have db access, though that's usually closely guarded (for good security reasons). Basically there's a reason there's like four or five different types of joins in SQL and this is it.