>Here's my pathetic attempt at the SQL. I've come to realise that I could really do with a course on this. I can't tell how successful it is as it won't work but I'm sure it's no good.

Can't offer you a course (though I am doing a session on SQL here at the German DevCon and again Monday in the Netherlands <s>), but you may find my e-book "Taming VFP's SQL" helpful. www.hentzenwerke.com.

Tamar