thanks for all your help guys, but unfortunatly although this will work, it would take me about a year to write this query, there are many thousands of rows in...