Im administrator of an MIS that uses  SQL 2000 - and while I can find my way around the db, create backups, use dts,  and write Crystal Reports from the data - I find it difficult to understand  how to create views ( so that my Crystal Report can report from the view rather than a group of tables.)

eg: I failed miserably at replication ( so I took my ball home and refused to play anymore!)

Im also at  a total loss to understand  'joins' -  the concept, how they work/how to use them  etc etc

Any Steve Jones style prompt sheets would be greatfully appreciated