trying to write a sql statement, using 8 tables, linking between them all with a hangover from hell. not good

Ian