> BTW, are there any good downloadable resource for SQL? hey lach, did you see my posts regarding resources for normalization? not that normalization is your current problem (i'll have a closer look at your query in a moment) http://lists.evolt.org/archive/Week-of-Mon-20020401/108569.html http://lists.evolt.org/archive/Week-of-Mon-20020401/108623.html rudy