Hi,

I cannot provide you with the direct Solution to the problem, however i can provide you a tip that will always help you and save your time in future.
It is a trick that helps me out in many cases.
If you are not doing it in MS Access import small tables  with sample data in CSV format in Access, use the visual mode of MS access to connect the data see the Query in Query mode, change the query in your required data base system similar to Access.
This has always helped me solving complex query structure. Hope this will help you out.

Thanks and Best Regards,

Scott Williams

Senior Computer Systems Engineer @EmlSearch

http://www.emlsearch.com/