I have worked with Sharepoint 2007, and as a developer, it was a nightmare. I left my internship after 1 month because of this technology.
I thought that all developers would think similarly to me, but this question has taught me differently. It seems possible for a developer to say "I love Sharepoint". Perhaps they've fallen into madness.
I'm not asking for information about Sharepoint which could easily be found in books, but instead I want to know what war stories or personal anecdotes do you have about Sharepoint 2007 development?
Perhaps format your responses this way:
Problem : Problem to solve which "should" be easy to do but isn't.
Solution : Solution or nasty tricks to know to resolve the problem.
Best Answer
Problem: "Join" data from multiple lists (especially with diferent fields) Solution: Lookup fields might help in few cases, but most of the time you have to join the list items programatically.